Summary
Deletes a geodatabase from a user's schema in Oracle.
Usage
The Delete Schema Geodatabase tool only deletes user-schema geodatabases in Oracle; it cannot delete the 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.
Syntax
arcpy.management.DeleteSchemaGeodatabase(input_database)
Parameter | Explanation | Data Type |
input_database | The database connection file (.sde) of the user-schema geodatabase to be deleted. You must connect as the schema owner. | Workspace |
Derived Output
Name | Explanation | Data Type |
out_workspace | The updated input workspace. | Workspace |
Code sample
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 land@ora11204.sde.
import arcpy
schema_gdb = "usr/connections/land@ora11204.sde"
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 = "usr/connections/land@ora11204.sde"
# Process: Delete Schema Geodatabase
arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
Environments
Licensing information
- Basic: No
- Standard: Yes
- Advanced: Yes