Import an DMP file that exports an Oracle database table

You can import the table structure and table data of one or more database tables into the export at the same time by importing and exporting DMP files. Here's how to import and export.

First enter the command line, click Start, enter cmd:

Enter, the command line window appears:

The Import command is: IMP username/password @ NETWORK service name File=xxx.dmp full=y;

Such as:

The exported command is: Exp username/password @ NETWORK SERVICE name file=xxx.dmp tables= (table name);

Such as:

Tip: When you export multiple tables, the table names are separated by commas such as:

Tables= (TABLE1,TABLE2,TABLE3).

Through these four steps, you can import and export the database table structure and the table data at the same time.