Unloading Data |
 Previous |
 Next |
You can use the Unload page to export the contents of a table to a text file or XML document.
Topics:
Unloading a Text File
Use the Unload to Text Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma-delimited file (.csv).
To unload a table to a text file:
-
On the Database Home Page, click the Utilities icon.
-
Click Data Load/Unload.
-
Click Unload.
-
Click Unload To Text.
The Unload to Text Wizard appears.
-
Follow the on-screen instructions.
You select the schema and choose the table and columns to be exported. You can also specify the type of separator to be used to separate column values as well as whether column text strings are identified using single or double quotation marks.
Unloading to an XML Document
Use the Unload to XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.
To unload a table to an XML document:
-
On the Database Home Page, click the Utilities icon.
-
Click Data Load/Unload.
-
Click Unload.
-
Click Unload to XML.
-
Follow the on-screen instructions.
You select the schema and choose the table and columns to be exported.