Exporting

For a complete syntax description of the Loader commands for exporting, see Exporting: Commands in the Loader manual.

Below are just a few examples of key export commands.

Prerequisites

You require the Demo Database DEMODB.

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

Example of an Export Command

Enter the export command you would like to use:

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.      into 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.

Examples

EXPORT DB

EXPORT USER

EXPORT SCHEMA

EXPORT TABLE

EXPORT COLUMNS

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