In this example,
emp is a partitioned table with three partitions:
A table-level export file was created using the following command:
> exp scott TABLES=emp FILE=exmpexp.dat ROWS=y
Information is displayed about the release of Export you are using and the release of Oracle Database that you are connected to. Then, status messages similar to the following are shown:
. . . About to export specified tables via Conventional Path ... . . exporting table EMP . . exporting partition P1 7 rows exported . . exporting partition P2 12 rows exported . . exporting partition P3 3 rows exported Export terminated successfully without warnings.
In a partition-level Import you can specify the specific partitions of an exported table that you want to import. In this example, these are
P3 of table
> imp scott TABLES=(emp:p1,emp:p3) FILE=exmpexp.dat ROWS=y
Information is displayed about the release of Import you are using and the release of Oracle Database that you are connected to. Status messages are also displayed.