匯出報錯:ORA-04063: package body "DMSYS.DBMS_DM_MODEL_EXP" has errors
Oracle 11.2.0.2 , EBS R12.1.3
因為是升級的資料庫系統, 保留了 DMSYS data mining 元件, 但是在庫中處於INVALID 狀態, 查詢 dba_registry 可以看到。
匯出metadata 時報錯:
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1282
ORA-04063: package body "DMSYS.DBMS_DM_MODEL_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DMSYS.DBMS_DM_MODEL_EXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8398
處理方法:
SQL> drop user DMSYS;
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = 'DMSYS';
SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SQL> SET HEAD OFF
SQL> SPOOL/DROP_DMSYS_SYNONYMS.SQL
SQL> SELECT 'Drop public synonym ' || SYNONYM_NAME || ' ;'
FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SQL> SPOOL OFF
SQL> @/DROP_DMSYS_SYNONYMS.SQL
SQL> EXIT;
已經不用dmsys了
因為是升級的資料庫系統, 保留了 DMSYS data mining 元件, 但是在庫中處於INVALID 狀態, 查詢 dba_registry 可以看到。
匯出metadata 時報錯:
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1282
ORA-04063: package body "DMSYS.DBMS_DM_MODEL_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DMSYS.DBMS_DM_MODEL_EXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8398
處理方法:
SQL> drop user DMSYS;
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = 'DMSYS';
SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SQL> SET HEAD OFF
SQL> SPOOL
SQL> SELECT 'Drop public synonym ' || SYNONYM_NAME || ' ;'
FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SQL> SPOOL OFF
SQL> @
SQL> EXIT;
已經不用dmsys了
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-1691639/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- expdp 報錯 ORA-04063: package body "SYS.DBMS_METADATA_UTIL" has errorsPackageError
- ORA-04063: package body "SYS.DBMS_EXPORT_EXTENSION" has errorsPackageExportError
- ORA-04063: package body "EXFSYS.DBMS_EXPFIL_EXP" has errorsPackageError
- ORA-04063: package body "SYS.LT_EXPORT_PKG" has errorsPackageExportError
- ORA-04063: package body SYS.DBMS_REGISTRY_SYS has errors (Doc ID 2165402.1)PackageError
- 由於字符集問題導致 Package Body created with compilation errors.PackageError
- 解決E: Package ‘libmysqlclient-dev‘ has no installation candidate報錯PackageIBMMySqlclientdev
- ORA-04042 procedure, function, package, or package body does not existFunctionPackage
- Package Specification 和 Package Body 及 Package有什麼區別? (轉)Package
- “setting.xml” has syntax errorsXMLError
- 包頭(Package)與包體(Package body)的學習與應用Package
- create or replace package body DBMS_ASSERT wrappedPackageAPP
- dbms_scheduler package body INVALID 解決方案Package
- 專案使用guzzleHttp報錯:certificate has expiredHTTP
- java bug2:settings.xml has syntax errorsJavaXMLError
- user_dependencies_trigger_view_package_body依賴ViewPackage
- ora-12012 ora-04063 報錯處理
- electron專案npm i 報錯certificate has expiredNPM
- Exp匯出報錯EXP-00091分析解決
- oracle 9.2.0.7 + hp_unix exp匯出報錯處理Oracle
- 解決Ubuntu報錯 E: Unable to locate package yumUbuntuPackage
- 【ORACLE 匯入匯出】exp 錯誤Oracle
- idea裡程式碼報黃色:XML tag has empty body less... (Ctrl+F1) Reports empty tag body. The validation works inIdeaXML
- kafka報錯解決 kafka.errors.NoBrokersAvailable: NoBrokersAvailableKafkaErrorAI
- Vue 啟動專案報錯 Failed to compile with 2 errorsVueAICompileError
- svn報錯“Previous operation has not finished; run 'cleanup' if it was int
- ovftool匯出虛擬機器報錯處理過程!虛擬機
- Method has too many Body parameters: public abstract com.cloud.module.smartkeCloud
- expdp匯出、transport_tablespace遇見ORA-04063、ORA-06508: PL/SQL:SQL
- 9i遠端匯出報錯ORA-12571
- PHP匯出報表(案例)PHP
- mysqlimport匯入報錯的排查MySqlImport
- Package ssh is not available, but is referred to by another package 錯誤PackageAI
- 自動任務出錯 ORA-12012 ORA-04063
- 修復 Ubuntu 中 “E: The package cache file is corrupted, it has the wrong hash”UbuntuPackage
- Linux yum安裝httpd報錯 No package httpd available ?LinuxhttpdPackageAI
- XML tag has empty body less... (Ctrl+F1) Reports empty tag body. The validation works in XML / JSPXMLJS
- PyTorch出現:RuntimeError: An attempt has been made to start a new process...報錯 (已解決)PyTorchError