An export from an Oracle9i database fails with:.... exporting triggersEXP-00056: ORACLE error 6550 encounteredORA-06550: line 1, column 26:PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declaredORA-06550: line 1, column 14:PL/SQL: Statement ignoredEXP-00056: ORACLE error 6550 encounteredORA-06550: line 1, column 26:PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declaredORA-06550: line 1, column 14:PL/SQL: Statement ignoredEXP-00000: Export terminated unsuccessfullyYou 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 selected2. 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> exitExplanation-----------The PLS-201 indicates that the export utility is expecting to find thepackge DBMS_XDBUTIL_INT. This package together with its package bodyshould exist in the XDB schema and should be valid.
转载于:https://www.cnblogs.com/hibernate315/archive/2010/04/16/2399288.html
相关资源：数据结构—成绩单生成器