Friday, November 14, 2008

Oracle Import Utility

Import extracts data from an export file and puts it back into an Oracle database. Import is command line not SQL command.

Table objects are imported from the export file in the following order:

1. Table definitions
2. Table data
3. Table indexes
4. Integrity constraints and triggers

Here are the list of import process order
1. New tables are created
2. Data is imported.
3. Indexes are built.
4. Triggers are imported,
5. Integrity constraints are enabled.

Note: Tablespace need to be create from the first place(if not exist), otherwise the object on the specific tablespace would not be able to be created.

To list exp parameter enter "exp HELP=y" .

More Information on Oracle Export at