Oracle9iEXPXDBDBMS_XDBUTIL_INTmustbedeclared

113 阅读 0 评论 75 点赞

我是靠谱客的博主高贵丝袜，最近开发中收集的这篇文章主要介绍Oracle9iEXPXDBDBMS_XDBUTIL_INTmustbedeclared，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

转 Oracle 9i EXP XDB.DBMS_XDBUTIL_INT must be declaredhttps://blog.csdn.net/tianlesoftware/article/details/5491811 An export from an Oracle9i database fails with:
...
. exporting triggers
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully

You have verified the following:

1. The package DBMS_XDBUTIL_INT object does not exist:

SQL> SELECT status,object_id,object_type,SUBSTR(owner||'.'||object_name,
1, 40) "OWNER.OBJECT" FROM dba_objects
WHERE object_name = 'DBMS_XDBUTIL_INT';

no rows selected

2. The error messages during export are identical as mentioned above.
For the error ORA-1422 (exact fetch returns more than requested number
of rows) in XDB.DBMS_XDBUTIL_INT (line 52), refer to:
- Note 221178.1 "ORA-01422 ORA-06512: at "XDB.DBMS_XDBUTIL_INT" while
exporting full database"
- Note 256548.1 "Export of Database with XDB Throws ORA-1422 Error"

Solution Description
--------------------
There are three possible solutions:

1. If you are *NOT* having any schema's in the database that use the
XML functionality, remove the XDB schema and the XDB tablespace by
following the steps in the article mentioned below. The XDB schema
and the XML functionality can be re-installed at a later time if
actually needed.

Note 243554.1 "How to Deinstall and Reinstall XML Database (XDB)"

WARNING: DO NOT DE-INSTALL XDB IF THERE ARE REGISTERED SCHEMA'S OR
IF XML DATABASE ITEMS HAVE BEEN CREATED !

2. If you are using the XML functionality, and you have recently applied
a patch-set, check whether the data dictionary has been upgraded
accordingly.

SQL> SELECT SUBSTR(comp_id,1,15) comp_id, status, SUBSTR(version,1,10)
version, SUBSTR(comp_name,1,30) comp_name
FROM dba_registry ORDER BY 1;

If the version of the components CATALOG, CATPROC, XDB (among others)
is lower than the patch-set version that you have applied, re-run the
script catpatch.sql after a startup migrate. See the readme file of
the patch-set for all these mandatory post-installation instructions.

3. If you are using the XML functionality, and the data dictionary
components have the correct version and are VALID or LOADED,
then re-create the package XDB.DBMS_XDBUTIL_INT with (example with
UNIX syntax):

SQL> connect sys/<password> AS SYSDBA
SQL> @?/rdbms/admin/prvtxdb.plb
SQL> exit

Explanation
-----------
The PLS-201 indicates that the export utility is expecting to find the
packge DBMS_XDBUTIL_INT. This package together with its package body
should exist in the XDB schema and should be valid.
https://img-blog.csdnimg.cn/20190217105710569.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTEwNzgxNDE=,size_16,color_FFFFFF,t_70《算法导论第三版英文版》_高清中文版.pdf
https://pan.baidu.com/s/17D1kXU6dLdU0YwHM2cvNMw
《深度学习入门：基于Python的理论与实现》_高清中文版.pdf
https://pan.baidu.com/s/1IeVs35f3gX5r6eAdiRQw4A
《深入浅出数据分析》_高清中文版.pdf
https://pan.baidu.com/s/1GV-QNbtmjZqumDkk8s7z5w
《Python编程：从入门到实践》_高清中文版.pdf
https://pan.baidu.com/s/1GUNSg4mdpeOf1LC_MjXunQ
《Python科学计算》_高清中文版.pdf
https://pan.baidu.com/s/1-hDKhK-7rDDFll_UFpKmpw