ITPub博客

首页 > Linux操作系统 > Linux操作系统 > impdp導入一個或多表

impdp導入一個或多表

Linux操作系统 作者:1362336695 时间:2015-07-15 11:14:33 0 删除 编辑

案例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/30273461/viewspace-1733790/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-06-04

  • 博文量
    61
  • 访问量
    87244