C: \ Users \ Administrator> impdp u1/U1 dumpfile = tmp_1.dmp directory = dir tables = Scott. tm_out_b1 logfile = 1.
Log
Import: Release 11.2.0.1.0-production on Monday May 7 16:53:06 2012
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the partitioning, OLAP, data mining and real application testing options
ORA-31655: data or metadata object not selected for the job
ORA-39154: objects in the external scheme have been deleted from the import
The master table "U1". "sys_import_table_01" is successfully loaded/uninstalled"
Start "U1". "sys_import_table_01": u1/******** dumpfile = tmp_1.dmp directory = dir tables = Scott. tm_out_b1
Logfile = 1.log
The job "U1". "sys_import_table_01" was successfully completed at 16:53:10.
Add remap_schema
C: \ Users \ Administrator> impdp u1/U1 dumpfile = tmp_1.dmp directory = dir tables = Scott. tm_out_b1 logfile = 1.
Log
Import: Release 11.2.0.1.0-production on Monday May 7 16:53:06 2012
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the partitioning, OLAP, data mining and real application testing options
ORA-31655: data or metadata object not selected for the job
ORA-39154: objects in the external scheme have been deleted from the import
The master table "U1". "sys_import_table_01" is successfully loaded/uninstalled"
Start "U1". "sys_import_table_01": u1/******** dumpfile = tmp_1.dmp directory = dir tables = Scott. tm_out_b1
Logfile = 1.log
The job "U1". "sys_import_table_01" was successfully completed at 16:53:10.
Note: tables = indicates that it is best to write the table name as an object (for example, Scott. tm_out_b1). Otherwise
C: \ Users \ Administrator> impdp u1/U1 dumpfile = tmp_1.dmp directory = dir tables = tm_out_b1 logfile = 1.log
Import: Release 11.2.0.1.0-production on Monday May 7 16:52:26 2012
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the partitioning, OLAP, data mining and real application testing options
ORA-39002: Invalid operation
ORA-39166: the object u1.tm _ out_b1 is not found.