报错现象: [oracle@sztech ~]$ expdp system/oracle directory=dump_dir dumpfile=dmpfile.dmp transport_tablespaces='tb1'; Export: Release 11.2.0.4.0 - Production on Wed Aug 10 11:59:00 2022 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. UDE-28002: operation generated ORACLE error 28002 ORA-28002: the password will expire within 7 days Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available
网上查了下,解决方法如下描述:
Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly. Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
执行如下:
SQL> execute dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed. SQL>
再次导出成功
[oracle@sztech dumpdir]$ expdp system/oracle directory=dump_dir dumpfile=dmpfile.dmp transport_tablespaces=tb1;
Export: Release 11.2.0.4.0 - Production on Wed Aug 10 12:03:25 2022 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. UDE-28002: operation generated ORACLE error 28002 ORA-28002: the password will expire within 7 days Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** directory=dump_dir dumpfile=dmpfile.dmp transport_tablespaces=tb1 Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK Processing object type TRANSPORTABLE_EXPORT/TABLE Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is: /u01/app/oracle/dumpdir/dmpfile.dmp ****************************************************************************** Datafiles required for transportable tablespace TB1: /u01/app/oracle/oradata/orcl/tb1.dbf Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at Wed Aug 10 12:04:01 2022 elapsed 0 00:00:35 [oracle@sztech dumpdir]$ |
重庆思庄oracle技术分享-expdp导出报错ORA-39006和ORA-39213解决
最新推荐文章于 2023-07-07 10:59:39 发布