14.3.2 call impdp -- import table

1. delete a table

C: \> sqlplus Scott/tiger @ orcl

SQL * Plus: Release 10.2.0.1.0-production on Sunday January 4 17:19:39 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options

SQL> drop table EMP;

The table has been deleted.

SQL> drop table dept;

The table has been deleted.

Ii. Export to your own solution

C: \> impdp Scott/tiger @ orcl directory = dump_dir dumpfile = tab. dmp tables = Dept, EMP

Import: Release 10.2.0.1.0-production on Sunday, 04 August 1, 2009 17:26:59

Copyright (c) 2003,200 5, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options
The master table "Scott". "sys_import_table_01" is successfully loaded/uninstalled"
Start "Scott". "sys_import_table_01": Scott/********* @ orcl directory = dump_dir dump
File = tab. dmp tables = Dept, EMP
Processing object type table_export/table
Processing object type table_export/table/table_data
.. Imported "Scott". "Dept" 5.656 kb 4 lines
.. Imported "Scott". "EMP" 7.820 kb 14 rows
Processing object type table_export/table/index/Index
Processing object type table_export/table/constraint/Constraint
Processing object type table_export/table/index/statistics/index_statistics
Processing object type table_export/table/constraint/ref_constraint
Processing object type table_export/table/statistics/table_statistics
The job "Scott". "sys_import_table_01" was successfully completed at 17:27:04.

Iii. Import to other solutions

C: \> impdp system/orcl @ orcl directory = dump_dir dumpfile = tab. dmp tables = Scott. Dept
, Scott. EMP remap_schema = SCOTT: System

Import: Release 10.2.0.1.0-production on Sunday, 04 August 1, 2009 17:29:02

Copyright (c) 2003,200 5, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options
The master table "system". "sys_import_table_01" is successfully loaded/uninstalled"
Start "system". "sys_import_table_01": System/********* @ orcl directory = dump_dir du
Mpfile = tab. dmp tables = Scott. Dept, Scott. EMP remap_schema = SCOTT: System
Processing object type table_export/table
Processing object type table_export/table/table_data
.. Imported "system". "Dept" 5.656 kb 4 lines
.. Imported "system". "EMP" 7.820 kb 14 rows
Processing object type table_export/table/index/Index
Processing object type table_export/table/constraint/Constraint
Processing object type table_export/table/index/statistics/index_statistics
Processing object type table_export/table/constraint/ref_constraint
Processing object type table_export/table/statistics/table_statistics
The job "system". "sys_import_table_01" was successfully completed at 17:29:07.