Importing

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.

Prerequisites

You require the Demo Database TESTDB. You have carried out an export of the required data.

Example of an Import Command

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'

This means:

...

       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.

Examples

IMPORT DB

IMPORT USER

IMPORT SCHEMA

IMPORT TABLE

IMPORT COLUMNS