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. 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, and 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 geodatabase. This, too, would need to be removed or unregistered before you could delete the user-schema geodatabase.

3. Be sure there are no users connected to the sde master geodatabase or any of the user-schema geodatabases.
4. Execute the sdesetup command with the delete operation to remove the ArcSDE 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.