Deleting a geodatabase from a user's schema

You can delete the ArcSDE geodatabase repository from a user's schema by doing the following:

Steps:

1. Make a backup of the database.
2. 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, mosaic datasets, and nonspatial tables—any object that contains a record in the TABLE_REGISTRY ArcSDE system table.

   This also applies to objects previously registered in another user's schema. For example, there could be a feature class in the user2 schema that is registered in the master geodatabase. This, too, would need to be removed before you could delete the user-schema geodatabase.

   If the data is no longer needed, it can be deleted. If it still needed, move it to another geodatabase using export or copy/paste, then delete it from the user schema geodatabase. Remember that if the data is versioned, you must reconcile and post all edits and compress before moving the data or edits will be lost.

3. Be sure there are no users connected to the sde master geodatabase or any of the user-schema geodatabases.

   You can use the sdemon command or the Connections tab of the Geodatabase Administration dialog box in ArcGIS for Desktop to see if users are connected.

4. Execute the sdesetup command with the delete operation to remove the ArcSDE geodatabase repository (the system tables, views, indexes, triggers, operators, packages, package bodies, libraries, type bodies, index types, and types) from the user's schema. See the ArcSDE Administration Command Reference for details on using the sdesetup command.

   sdesetup -o delete -d ORACLE11G -u theschemaowner 
   -p nomira -i 5151:theschemaowner
   

   Caution:

   Be sure to specify the user-schema information with the –i option; if you do not, sdesetup will attempt to delete the sde master geodatabase.