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.
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
Enter the export command you would like to use:
EXPORT TABLE hotel.city
CATALOG OUTSTREAM 'city_ddl.catalog'
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.
You can use the export data streams you have created in this way for Importing the data to a database instance of your choice.