用数据泵导出导入的时候报如下错误的解决方法:
impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;
Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:35:19 2011
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is notavailable
解决方法:
SQL> conn / as sysdba;
Connected.
SQL> execute sys.dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
再次impdp 成功:
impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;
Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:39:40 2011
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
Master table "DAVE"."SYS_IMPORT_TABLE_01"successfully loaded/unloaded
Starting"DAVE"."SYS_IMPORT_TABLE_01": dave/******** directory=backupdumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace
Processing object typeTABLE_EXPORT/TABLE/TABLE
Processing object typeTABLE_EXPORT/TABLE/TABLE_DATA
. . imported"DAVE"."PDBA" 49.14 MB 2713235rows
Job"DAVE"."SYS_IMPORT_TABLE_01" successfully completed at 12:40:16
impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;
Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:35:19 2011
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is notavailable
解决方法:
SQL> conn / as sysdba;
Connected.
SQL> execute sys.dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
再次impdp 成功:
impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;
Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:39:40 2011
Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
Master table "DAVE"."SYS_IMPORT_TABLE_01"successfully loaded/unloaded
Starting"DAVE"."SYS_IMPORT_TABLE_01": dave/******** directory=backupdumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace
Processing object typeTABLE_EXPORT/TABLE/TABLE
Processing object typeTABLE_EXPORT/TABLE/TABLE_DATA
. . imported"DAVE"."PDBA" 49.14 MB 2713235rows
Job"DAVE"."SYS_IMPORT_TABLE_01" successfully completed at 12:40:16
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29330852/viewspace-1078329/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29330852/viewspace-1078329/