impdp導入一個或多表

案例1
[oracle@test ecard_bk]$ impdp ftest/ftestdirectory=dump_file_dir dumpfile=ecard_2013_03_01.dump logfile=h4.log tables=fathr.KQ_NOT_EMPOTTYPE,fathr.KQ_EMPG
ROUP_806,fathr.KQ_EMPGROUP,fathr.CEN_CODE
出現以下錯誤：
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type

TABLE:"FATHR"."KQ_NOT_EMPOTTYPE" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type

TABLE:"FATHR"."KQ_EMPGROUP_806" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type

TABLE:"FATHR"."KQ_EMPGROUP" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type

TABLE:"FATHR"."CEN_CODE" creation failed
Job "FATHR"."SYS_IMPORT_TABLE_01" completed with 48 error(s) at 08:38:39

解決添加TRANSFORM=SEGMENT_ATTRIBUTES:N

[oracle@test ecard_bk]$ impdp ftest/ftest directory=dump_file_dir dumpfile=ecard_2013_03_01.dump logfile=h4.log tables=fathr.KQ_NOT_EMPOTTYPE,fathr.KQ_EMPG
ROUP_806,fathr.KQ_EMPGROUP,fathr.CEN_CODE TRANSFORM=SEGMENT_ATTRIBUTES:N

案例2
impdp system/test directory=DUMPDIR dumpfile=expdphasfcdb120130306.dmp  logfile=sfc.log

tables=sfcdata.sfccode
報錯如下：
ORA-39151: Table "SFCDATA"."SFCCODE" exists. All dependent metadata and data will be skipped due

to table_exists_action of skip
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 08:50:12

直接備份sfcdata.sfccode 然後drop sfcdata.sfccode
SQL> grant read,write on directory dumpdir to sfcdata;

Grant succeeded.

impdp  directory=DUMPDIR dumpfile=expdphasfcdb120130306.dmp  logfile=sfc.log

tables=sfcdata.sfccode
用sfcdata用戶導入

oK

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15187685/viewspace-755448/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15187685/viewspace-755448/