For a complete syntax description of the Loader commands for importing, see Importing: Commands in the Loader manual.
Below are just a few examples of key import commands.
Start the Loader as database administrator MONA with password RED for database TESTDB (Calling the Loader). Create the HOTEL schema.
Import the database catalog data you exported into the HOTEL schema of the TESTDB test database.
IMPORT TABLE hotel.city
CATALOG INSTREAM 'city_ddl.catalog'
1. Import (IMPORT)
2. a table (TABLE)
3. called CITY (hotel.city)
4. Import the database catalog data (CATALOG)
5. from the input file (INSTREAM)
6. called city_ddl.catalog
All objects (such as view tables, indexes) dependent on the CITY table that are listed in city_ddl.catalog are imported. If additional objects are necessary for the creation of a dependent object (for example, additional tables for creating a view table), the dependent objects are only imported if the additional objects are available.