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.
<!--EndFragment-->
分享到:
相关推荐
封装BerkeleyDB的一个动态库,多余的就不说了。
this is a AND gate (32 bit)
ojdbc6.jar orai18n.jar xdb.jar xmlparserv2.jar
java操作oralce数据库的jar包。
Oracle_XDB_FTP_PASS-利用 利用Oracle 9i XDB ftp密码缓冲区溢出漏洞->
oracle xmltype 类型 jdbc 的相关jar包 包含 ojdbc8.jar orai18n.jar xdb6.jar xdb.jar xmlparserv2.jar
dbeaver oracle连接所需的xdb6.jar orai18n.jar
jar包,官方版本,自测可用
Oracle监听器中的XDB、_XPT、_DGMGRL 、_DGB、PLSExtProc服务_ITPUB博客.mhtml
oracle数据库xmltype类型解析使用的jar包,xdb6.jar、xmlparserv2.jar
一个表有一个字段为xml_col是xmltype类型,应用jdbc从数据库中查询到xml_c并取出
xdb转换txt工具
关于ST7701S+CTC3.97TN的测试程序,可以调试
ojdbc8.jar ojdbc7.jar xdb6.jar orai18n.jar打包上传,自行下载使用,一些数据库可视化工具需要以上jar包,自行导入使用
工业控制领域经常会碰到诸如14/12位这种数据算法需求,实现数据往往是溢出的,这就需要取舍,获得准确的数据,如陀螺仪,地标二维码等等 在本文详细说明了步骤并以源码方式详尽的记录了下来,以供有需要的朋友参考。...
在学习和工作的过程中,我们可能在调试程序时发现...如果出现这种情况,本文介绍了如下三种方法来解决问题:更改TOMCAT的默认端口、使用Enterprise Manager Console、使用sys登录Oracle,利用dbms_xdb修改端口设置。
本文介绍了配置Oracle监听器的方法。
ojdbc6.jar ojdbc6_g.jar ojdbc6dms.jar ojdbc6dms_g.jar ojdbc7.jar ojdbc7_g.jar ojdbc7dms.jar ojdbc7dms_g.jar ons.jar orai18n.jar simplefan.jar ucp.jar xdb6.jar 文件合集
解决error LNK2001 无法解析的外部符号 int __cdecl sprintf