AnsweredAssumed Answered

Delete a user schema geodatabase

Question asked by sherriekubis on Feb 1, 2011
Latest reply on Feb 1, 2011 by tval-esristaff
Oracle 11.1.0.7
SDE 9.3.1 SP2

We have a master geodatabase and six user-schema geodatabases in the same Oracle instance. I need to delete one of the user-schema geodatabases.

Documentation states:

Unregister or remove from the user's schema all data that is registered with ArcSDE and/or the geodatabase. This includes such objects as feature datasets, stand-alone feature classes, raster datasets, raster catalogs, nonspatial tablesâ??any object that contains a record in the TABLE_REGISTRY ArcSDE system table. This also applies to objects registered in another user's schema. For example, there could be a feature class in the user2 schema that is registered in the master SDE geodatabase. This, too, would need to be removed or unregistered before you could delete the user-schema geodatabase.
I read this to mean that all data in the master and user schema geodatabases must be deleted before a user schema can be dropped. Can this be right? Or am I reading this wrong. I keep thinking it can't be that all of my base data, as well as my five other application geodatabases must be whacked to get rid of one errant geodatabase that is no longer important.

Does anyone have any insights into this? I have a prototype area to test and can then flashback if need be, but perhaps someone has crossed this bridge already.

Outcomes