重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛
标题: ORA-39213： Metadata processing is not available 解决方法 [打印本页]
作者: jiawang 时间: 2019-1-9 17:47
标题: ORA-39213： Metadata processing is not available 解决方法
本帖最后由 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导入成功
