The Delete Schema Geodatabasetool deletes a schema geodatabase from an Oracle database.
The Delete Schema Geodatabasetool only works with geodatabases in Oracle.
Only the owner of the schema geodatabase can run the Delete Schema Geodatabase tool.
You must remove all data from the user-schema geodatabase before you can delete the geodatabase.
Specify the database connection (.sde) file for the schema geodatabase you want to delete. You must connect as the schema owner.
DeleteSchemaGeodatabase example 1 (Python window)
You can alter and run the following from a Python window to delete a user-schema geodatabase. This example connects through the database connection file firstname.lastname@example.org to delete a user-schema geodatabase.
import arcpy schema_gdb = "email@example.com" arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
DeleteSchemaGeodatabase example 2 (stand-alone Python script)
The following is a stand-alone script you can alter and run to delete a user-schema geodatabase:
# Set the necessary product code import arceditor # Import arcpy module import arcpy # Local variables: schema_gdb = "firstname.lastname@example.org" # Process: Delete Schema Geodatabase arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
- ArcGIS for Desktop Basic: No
- ArcGIS for Desktop Standard: Yes
- ArcGIS for Desktop Advanced: Yes