Using Import - Export

To use Export, you must run the script CATEXP.SQL or CATALOG.SQL (which runs CATEXP.SQL) after the database has been created.

You can invoke Export in one of the following ways:

C:\>exp username/password PARFILE=filename

Enter the following command, adding any needed parameters:

C:>\exp username/password

The following example shows a partial parameter file listing:

TABLES=(scott.emp , blake.dept) FILE=export01.dmp GRANTS=Y INDEXES=Y DIRECT=Y
CONSISTENT=Y #Export is consistent to a single point in time and does not change during the execution of the export command.

exp scott/tiger tables=emp query="where job='SALESMAN' and sal<1600"

Import Modes

TABLES	This mode allows you to import specific tables and partitions. A privileged user can qualify the tables by specifying the schema that contains them.
FROMUSER	This mode allows you to import all objects that belong to you (such as tables, grants, indexes, and procedures). A privileged user importing in user mode can import all objects in the schemas of a specified set of users.
FULL	Only users with the IMP_FULL_DATABASE role can import in this mode, which imports a full database export dump file.
TRANSPORT_TABLESPACES	This mode allows a privileged user to move a set of tablespaces from one Oracle database to another.

	`C:\>imp` username/password PARFILE=filename
	`C:\>imp username/password <parameters>`
	`C:\>imp username/password`

The following example shows a partial parameter file listing:

FILE=export01.dmp
SHOW=n
IGNORE=n
GRANTS=y
FROMUSER=scott
TABLES=(dept,emp)