Oracle 9i EXP XDB.DBMS_XDBUTIL_INT must be declared

ijavagos

浏览: 1241722 次
性别:
来自: 北京

最近访客更多访客>>

abc123

bigguo

eteryang

figure

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (1536)

社区版块

存档分类

2011-10 ( 74)
2011-09 ( 59)
2011-08 ( 29)
更多存档...

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.