topic Remove SDE in Data Management Questions

Remove SDE

ScottNoldy — Tue, 17 Dec 2013 19:19:11 GMT

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.

Re: Remove SDE

VinceAngelo — Tue, 17 Dec 2013 19:37:27 GMT

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

Re: Remove SDE

ScottNoldy — Wed, 18 Dec 2013 13:08:03 GMT

Thanks for the help Vince.

Is the above the same if we're using SDO_Geometry instead of ST_Geometry?

Re: Remove SDE

VinceAngelo — Wed, 18 Dec 2013 15:19:41 GMT

If you've exclusively used SDO_GEOMETRY, and never used SDE.ST_GEOMETRY, then
there would be no users to drop. The ST_GEOMETRY calalog would still contain the
SDE tables with ST_GEOMETRY types, but that's all. You should certainly look for
rogue ST_GEOMETRY columns before dropping SDE.

- V