| SDO_GEOM_METADATA table missing [message #212160] |
Thu, 04 January 2007 01:01  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Oracle Version -- 9.2.0.6
OS -- Windows
When I am trying to drop a user, it fails with the error that
ORA-604 : error occurred at recursive SQL level 1
ORA-942 : table or view does not exist
and when i traced the session then found that the command is throwing error while deleting from SDO_GEOM_METADATA table as the table does not exist.
I have already run "catmd.sql" script but the problem persist.
Any inputs are welcome.
warm regards,
Tarun Dua
|
|
|
|
| Re: SDO_GEOM_METADATA table missing [message #214785 is a reply to message #212160] |
Thu, 18 January 2007 01:37  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Well , the problem got resolved . Removed MDSYS user as it was not required and drop all the object owned by SYS and starts with 'SDO%' .
And in fact, dropped the trigger that was causing problem.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
