本帖最后由 jiawang 于 2019-1-10 09:11 编辑
报错现象:[oracle@strong_dg admin]$ impdp system/oracle DIRECTORY=DMP_DIR NETWORK_LINK=link_sztech full=y Import: Release 11.2.0.4.0 -Production on nWed Jan 9 16:22:40 2019
Copyright (c) 1982, 2011, Oracleand/or itsaffiliates. All rights reserved.
Connected to: Oracle Database11gEnterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, DataMiningand Real Application Testing options
ORA-39006: internal error ORA-39213: Metadata processing isnotavailable
[size=15.3333px]网上查了下,解决方法如下描述: [size=15.3333px] Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly. [size=15.3333px] Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.
解决办法: 运行脚本: SQL> conn / as sysdba; Connected.
SQL> execute sys.dbms_metadata_util.load_stylesheets; PL/SQL procedure successfullycompleted.
再次执行impdp导入成功 |