| Views missing - XDB.PATH_View and XDB.Resource_View [message #279835] |
Sun, 11 November 2007 00:10  |
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,......
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
