Oracle 9i EXP XDB.DBMS_XDBUTIL_INT must be declared

最新推荐文章于 2021-04-14 05:55:51 发布

iteye_20309

最新推荐文章于 2021-04-14 05:55:51 发布

阅读量93

点赞数

文章标签：数据库

AnexportfromanOracle9idatabasefailswith:
...
.exportingtriggers
EXP-00056:ORACLEerror6550encountered
ORA-06550:line1,column26:
PLS-00201:identifier'XDB.DBMS_XDBUTIL_INT'mustbedeclared
ORA-06550:line1,column14:
PL/SQL:Statementignored
EXP-00056:ORACLEerror6550encountered
ORA-06550:line1,column26:
PLS-00201:identifier'XDB.DBMS_XDBUTIL_INT'mustbedeclared
ORA-06550:line1,column14:
PL/SQL:Statementignored
EXP-00000:Exportterminatedunsuccessfully

Youhaveverifiedthefollowing:

1.ThepackageDBMS_XDBUTIL_INTobjectdoesnotexist:

SQL>SELECTstatus,object_id,object_type,SUBSTR(owner||'.'||object_name,
1,40)"OWNER.OBJECT"FROMdba_objects
WHEREobject_name='DBMS_XDBUTIL_INT';

norowsselected

2.Theerrormessagesduringexportareidenticalasmentionedabove.
FortheerrorORA-1422(exactfetchreturnsmorethanrequestednumber
ofrows)inXDB.DBMS_XDBUTIL_INT(line52),referto:
-Note221178.1"ORA-01422ORA-06512:at"XDB.DBMS_XDBUTIL_INT"while
exportingfulldatabase"
-Note256548.1"ExportofDatabasewithXDBThrowsORA-1422Error"

SolutionDescription
--------------------
Therearethreepossiblesolutions:

1.Ifyouare*NOT*havinganyschema'sinthedatabasethatusethe
XMLfunctionality,removetheXDBschemaandtheXDBtablespaceby
followingthestepsinthearticlementionedbelow.TheXDBschema
andtheXMLfunctionalitycanbere-installedatalatertimeif
actuallyneeded.

Note243554.1"HowtoDeinstallandReinstallXMLDatabase(XDB)"

WARNING:DONOTDE-INSTALLXDBIFTHEREAREREGISTEREDSCHEMA'SOR
IFXMLDATABASEITEMSHAVEBEENCREATED!

2.IfyouareusingtheXMLfunctionality,andyouhaverecentlyapplied
apatch-set,checkwhetherthedatadictionaryhasbeenupgraded
accordingly.

SQL>SELECTSUBSTR(comp_id,1,15)comp_id,status,SUBSTR(version,1,10)
version,SUBSTR(comp_name,1,30)comp_name
FROMdba_registryORDERBY1;

IftheversionofthecomponentsCATALOG,CATPROC,XDB(amongothers)
islowerthanthepatch-setversionthatyouhaveapplied,re-runthe
scriptcatpatch.sqlafterastartupmigrate.Seethereadmefileof
thepatch-setforallthesemandatorypost-installationinstructions.

3.IfyouareusingtheXMLfunctionality,andthedatadictionary
componentshavethecorrectversionandareVALIDorLOADED,
thenre-createthepackageXDB.DBMS_XDBUTIL_INTwith(examplewith
UNIXsyntax):

SQL>connectsys/<password>ASSYSDBA
SQL>@?/rdbms/admin/prvtxdb.plb
SQL>exit

Explanation
-----------
ThePLS-201indicatesthattheexportutilityisexpectingtofindthe
packgeDBMS_XDBUTIL_INT.Thispackagetogetherwithitspackagebody
shouldexistintheXDBschemaandshouldbevalid.