Home » Server Options » Spatial » SDO_GEOM_METADATA table missing
SDO_GEOM_METADATA table missing [message #212160] Thu, 04 January 2007 01:01 Go to next message
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 Go to previous message
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.
Previous Topic: how to run mapviewer??
Next Topic: ORA-13226 Using Spatial operator
Goto Forum:
  


Current Time: Thu Mar 28 14:35:51 CDT 2024