topic Re: Unable to drop SDE schema and a user schema and some objects in Data Management Questions

Unable to drop SDE schema and a user schema and some objects

HaniuHokkaido — Wed, 10 Oct 2012 09:18:01 GMT

Dear all,

I have trouble in deleting schemas: sde schema and a user schema.

There is no table in SDE schema, but there are some objects: ST_CURVE, ST_DOMAIN_STATS, ST_GEOMETRY, ST_GEOMCOLLECTION. But when i try to delete the table an error comes up: "ORA-02303: cannot drop or replace a type with type or table dependents"

There is a table in the user schema, GDB_ITEMS. When I want to delete this then error comes up:
ORA-00604: error occurred at recursive SQL level 1
ORA-21700: object does not exist or is marked for delete

What should I do ? How to force delete the table ? How will you force delete the objects ? It seems there is a dependency problem

thanks

Re: Unable to drop SDE schema and a user schema and some objects

VinceAngelo — Wed, 10 Oct 2012 10:57:23 GMT

If you *really* want to delete the SDE user, you would use the database command
DROP USER SDE CASCADE.

HOWEVER, if you do this when any other user has a table with a ST_GEOMETRY
column you will irrevocably corrupt your Oracle instance (which is why the
database tries to enforce referential integrity constraints).

- V

Re: Unable to drop SDE schema and a user schema and some objects

HaniuHokkaido — Thu, 11 Oct 2012 01:59:22 GMT

Hi Vince,

Thats exactly what i was doing, drop the sde user. But that errors always come up and i am unable to delete it.

So, what to do now ?