| Can't Install Oracle XML db component [message #566245] |
Wed, 12 September 2012 00:27  |
 |
sikakaito
Messages: 6
Registered: July 2012
Location: Manila
|
Junior Member |
|
|
Hi all,
I am trying to install the oracle xml database component and i'm encountering errors.
i followed the documentation but it wasn't a success.
here is the error.
create or replace type XDB.XDB$RESOURCE_T OID
ERROR at line 1:
ORA-21700: object does not exist or is marked for delete
grant execute on xdb.xdb$resource_t to public with grant option
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
create table XDB.XDB$RESOURCE of sys.xmltype
ERROR at line 1:
ORA-00902: invalid datatype
alter table XDB.XDB$RESOURCE add (ref(xmldata.XMLREF) with rowid)
ERROR at line 1:
ORA-00942: table or view does not exist
i am a newbie in this matter. please help me.
By the way i am still using oracle9i.(i know its old but its our company's database)
Thank You for your future replies.
|
|
|
|
|
|
|
|
|
|
| Re: Can't Install Oracle XML db component [message #566261 is a reply to message #566245] |
Wed, 12 September 2012 01:41  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Hi - you do need to sort this out: I remember that you can't upgrade to 10g without XDB. If it isn't already installed, the upgrade process attempts (and, presumably, will fail) to install it. So unless you use export/import, you will never be able to upgrade.
I guess you do not have a support contract, so you are on tour own?
Perhaps some XDB objects already exist. You can remove XDV with the catnoqm.sql script, I would try that and then install again.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
