ORA-39213: Metadata processing is not available 解決方案
向資料庫匯入資料:
[oracle@localhost-a ~]$ impdp system/123456@prod DIRECTORY=dpdata1 DUMPFILE=test.dmp SCHEMAS=test
Import: Release 11.2.0.1.0 - Production on Wed Aug 31 17:40:07 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.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
使用oerr命令檢視錯誤資訊:
[oracle@localhost-a ~]$ oerr ora 39213
39213, 00000, "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.
按照提示進行操作,解決問題:
[oracle@localhost-a ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 31 17:44:22 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> execute dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
重新執行匯入操作:
[oracle@localhost-a ~]$ impdp system/123456@prod DIRECTORY=dpdata1 DUMPFILE=test.dmp SCHEMAS=test
Import: Release 11.2.0.1.0 - Production on Wed Aug 31 17:44:58 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/********@prod DIRECTORY=dpdata1 DUMPFILE=test.dmp SCHEMAS=test
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
…………
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
匯入成功!!!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31394774/viewspace-2142126/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- expdp, impdp ORA-39213 Metadata processing not availableAI
- ORA-39213: Metadata processing is notavailableAI
- 從Oracle11g impdp到oracle10g報錯ORA-39213: Metadata processing is not availableOracleAI
- 求metadata相關工具或解決方案建議
- No Task Available解決方法AI
- SQL java.sql.SQLException: Parameter metadata not available for the given statementSQLJavaExceptionAI
- Windows 10 下 Homestead/VM 啟動提示 VT-x is not available 解決方案WindowsAI
- 解決:Failed to download metadata for repo ‘base‘AI
- DBMS_METADATA報錯解決方法
- MySQL DDL Waiting for table metadata lock 解決MySqlAI
- opatch option Not available yet問題的解決方法AI
- 解決ora-01034:oracle not available 的方法OracleAI
- 解決方案| anyRTC金融音視訊解決方案
- 解決 Sorry,this Adobe app is not available 問題的方法APPAI
- ORA-01034: ORACLE not available的解決辦法OracleAI
- LAMP解決方案LAMP
- 高併發解決方案詳解(9大常見解決方案)
- 解決Parameter '__frch_item_0' not found. Available parameters 問題AI
- 解決rpmdb: Lock table is out of available locker entries問題。AI
- ios不支援fixed解決解決方案iOS
- 程式碼改造引發的NoSuchBeanDefinitionException:no bean named 'XXXX' available問題解決方案BeanExceptionAI
- 前端整合解決方案前端
- 高可用解決方案
- UnexpectedRollbackException解決方案Exception
- Feast on Amazon 解決方案AST
- 埠占用解決方案
- Swift 5 Type Metadata 詳解Swift
- Spring中出現:No bean named 'XXX' available問題解決SpringBeanAI
- 智慧停車場解決方案,反向尋車系統解決方案
- 跨域問題,解決方案 – CORS方案跨域CORS
- 跨域問題,解決方案 - CORS方案跨域CORS
- 【Bug解決】CentOS-8中“Failed to download metadata for repo ‘AppStreamCentOSAIAPP
- 智慧農業解決方案
- 大資料解決方案大資料
- javascript非同步解決方案JavaScript非同步
- mysql壓縮解決方案MySql
- 非同步解決方案---promise非同步Promise
- ROS意外崩掉解決方案ROS