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.
You can use the demo data of 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.
Enter the desired export command:
EXPORT TABLE hotel.city
CATALOG OUTSTREAM 'city_ddl.catalog'
This means:
Export (EXPORT)
a table (TABLE)
from the HOTEL schema called CITY (hotel.city)
Export the database catalog data (CATALOG)
to the output file (OUTSTREAM)
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.
You can use the export data streams you have created in this way to import the data to a database of your choice.