Remove SDE

622
3
Jump to solution
12-17-2013 11:19 AM
ScottNoldy
New Contributor III
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.
0 Kudos
1 Solution

Accepted Solutions
VinceAngelo
Esri Esteemed Contributor

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

View solution in original post

0 Kudos
3 Replies
VinceAngelo
Esri Esteemed Contributor

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

0 Kudos
ScottNoldy
New Contributor III
Thanks for the help Vince.

Is the above the same if we're using SDO_Geometry instead of ST_Geometry?
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos