Background documentationExporting Locate this document in the navigation structure

 

For a complete syntax description of the Loader commands for exporting, see Exporting: Commands in the Loader documentation. The following section will give some examples of key export commands.

Prerequisites

You can use the demo data of demo database DEMODB.

Example

Start the Loader and log on to the demo database DEMODB as database administrator MONA with the password RED. Use the session mode: loadercli -d demodb -u mona,red.

Enter the desired export command:

EXPORT TABLE hotel.city

  CATALOG OUTSTREAM 'city_ddl.catalog'

This means:

  1. Export (EXPORT)

  2. a table (TABLE)

  3. from the HOTEL schema called CITY (hotel.city)

  4. Export the database catalog data (CATALOG)

  5. to the output file (OUTSTREAM)

  6. called city_ddl.catalog

All object definitions (such as view tables) dependent on the CITY table are also exported to the city_ddl.catalog file.

More Information

EXPORT DB

EXPORT USER

EXPORT SCHEMA

EXPORT TABLE

EXPORT COLUMNS

Session Mode

You can use the export data streams you have created in this way to import the data to a database of your choice.