The Delete Schema Geodatabase tool deletes a geodatabase from a user's schema in Oracle.
The Delete Schema Geodatabasetool only works with user-geodatabases in Oracle; it cannot delete the master sde geodatabase.
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 user-schema geodatabase you want to delete. You must connect as the schema owner.
The updated input workspace.
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 email@example.com to delete a user-schema geodatabase.
import arcpy schema_gdb = "firstname.lastname@example.org" arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
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 = "email@example.com" # Process: Delete Schema Geodatabase arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
- Basic: No
- Standard: Yes
- Advanced: Yes