Remove SDE

ScottNoldy

On a test server SDE 10.2 was installed in it's own schema.  There is a also a user schema that contains feature classes along with other data.  Is it possible to remove all traces of ArcSDE from the database without losing other data in that user schema?

Oracle 11g

I'm a SQL Server dba and don't know much about Oracle but do know SDE.  I'm working with the Oracle dba on this.

VinceAngelo

You can "DROP USER SDE CASCADE" IF AND ONLY IF no other user has a table which uses

one of the SDE user's object types (e.g., no tables with an SDE.ST_GEOMETRY column).

If you drop the SDE user while some user references SDE-owned objects, it will cause the
DROP to partially fail, and set up a referential integrity issue within the database instance,

where further attempts to DROP will fail due to missing objects (and attempts to create

a new SDE login will fail due to conflicting objects,...).  The only solution to this is dropping
the database instance and restoring from backup.

The safest procedure would be to drop all the users that had SDE.ST_GEOMETRY at any time,
then recreate the user(s) and restore the non-ST_GEOMETRY table(s).

- V