Home » Developer & Programmer » JDeveloper, Java & XML » Views missing - XDB.PATH_View and XDB.Resource_View (RDBMS Version:: Oracle 9.2.0.1)
Views missing - XDB.PATH_View and XDB.Resource_View [message #279835] Sun, 11 November 2007 00:10 Go to next message
dwhbala
Messages: 2
Registered: November 2007
Junior Member
The below 2 view are missing in XDB
XDB.PATH_View and XDB.Resource_View
This is causing problems during Oracle upgrade from 9.2.0.1 to 9.2.0.3.

The CatPatch.sql is giving an error saying these 2 views are missing. If I try to recreate them from another server (copy the code) it is still givig problems. Unable to compile the code and create the view successfully.

I donot know whether they are standard views or customizable views. Can I copy these views from server to another server, or what should I do. Any package or source code availability that will help me recreate these missing views.

Please let me know how to create these two views.
XDB.PATH_View and XDB.Resource_View

Thanks
Bala.
Operating System and Version:: Solaris 64 bit
Error Number (if applicable)::
Product (i.e. Trace, DB Diff, Expert, etc):: Oracle 9
Product Version:: Oracle Database 9.2.01
OEM Console Operating System and Version:: SOlaris 64 bit

Error message...
ORA-00600: internal error code,......
Re: Views missing - XDB.PATH_View and XDB.Resource_View [message #279843 is a reply to message #279835] Sun, 11 November 2007 00:31 Go to previous message
mikey1234in
Messages: 9
Registered: January 2007
Location: Bangalore
Junior Member

Try to manually de-install and re-install XDB as per Document ID 243554.1 : How to Deinstall and Reinstall XML Database (XDB)
Previous Topic: XPath - get element name - works in v11g, not in 10g
Next Topic: How can I begin in java ?
Goto Forum:
  


Current Time: Thu Mar 28 11:47:56 CDT 2024