How to validate the packages DBMS_METADATA_INT and DBMS_METADATA_UTIL
How to validate the packages DBMS_METADATA_INT and DBMS_METADATA_UTIL
Goal
The following objects were found invalid while querying dba_objects:
OWNER OBJECT_NAME OBJECT_TYPE STATUS
---------- ------------------------------ ------------------- -------
SYS DBMS_METADATA_INT PACKAGE BODY INVALID
SYS DBMS_METADATA_UTIL PACKAGE BODY INVALID
When trying to compile manually, you get the following errors:
SQL> alter package sys.dbms_metadata_util compile;
SP2-0809: Package altered with compilation warnings
SQL> show errors;
Errors for PACKAGE SYS.DBMS_METADATA_UTIL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
130/9 PLW-06010: keyword "VALUE" used as a defined name
158/31 PLW-06010: keyword "TYPE" used as a defined name
211/17 PLW-06010: keyword "LENGTH" used as a defined name
214/17 PLW-06010: keyword "ROW" used as a defined name
229/17 PLW-06010: keyword "LENGTH" used as a defined name
232/17 PLW-06010: keyword "ROW" used as a defined name
245/17 PLW-06010: keyword "LENGTH" used as a defined name
248/17 PLW-06010: keyword "ROW" used as a defined name
261/17 PLW-06010: keyword "LENGTH" used as a defined name
264/17 PLW-06010: keyword "ROW" used as a defined name
281/17 PLW-06010: keyword "LENGTH" used as a defined name
Solution
Please run the following script which will re-create those packages and type bodies :
$ORACLE_HOME/rdbms/admin/catpprvt.sql
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-1063618/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to prevent your jar packages from being decompiled?JARPackageCompile
- validate
- python modules and packagesPythonPackage
- jQuery Validate highlight()jQuery
- jQuery Validate addMethod()jQuery
- jQuery Validate errorPlacement()jQueryError
- jQuery Validate success()jQuery
- jQuery Validate unhighlight()jQuery
- [LeetCode] Validate IP AddressLeetCode
- jQuery Validate optional()方法jQuery
- 每日一個 Golang PackagesGolangPackage
- How to ssh
- Vue Element校驗validateVue
- jQuery Validate的format()用法jQueryORM
- Unofficial Windows Binaries for Python Extension PackagesWindowsPythonPackage
- How to find dependency
- jQuery Validate簡單介紹jQuery
- Validator | validate 驗證規則
- npm publish gives “unscoped packages cannot be private”NPMPackage
- [譯] WebAssembly: How and whyWeb
- How OpenStack integrates with Ceph?
- How to Build a Cybersecurity CareerUI
- CISO之What & How
- How to Restart Qt ApplicationRESTQTAPP
- How Python list works?Python
- How to Install psql on MacSQLMac
- How to Install LibreOffice on UbuntuUbuntu
- jQuery Validate checkbox和radio驗證jQuery
- jquery.validate 表單驗證jQuery
- validate表單驗證外掛
- jQuery Validate依賴項介紹jQuery
- LeetCode 98. Validate Binary Search TreeLeetCode
- $request->validate()原始碼解讀原始碼
- Vue packages version conflicts 錯誤修復VuePackage
- 每日一個 Golang Packages 06/11 syncGolangPackage
- 每日一個 Golang Packages 06/10 runtimeGolangPackage
- 每日一個 Golang Packages 06/04 timeGolangPackage
- 每日一個 Golang Packages 06/05 stringsGolangPackage
- 每日一個 Golang Packages 06/09 mathGolangPackage