Delete Schema Geodatabase (Data Management Tools)
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.
Parameters
Label
Explanation
Data type
Input Database Connection
The database connection file (.sde) of the user-schema geodatabase to be deleted. You must connect as the schema owner.
Workspace
Derived output
Label
Explanation
Data type
Updated Input Workspace
The updated input workspace.
Workspace
arcpy.management.DeleteSchemaGeodatabase(input_database)
Name
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
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 land@ora11204.sde.
import arcpy
schema_gdb = "usr/connections/land@ora11204.sde"
arcpy.management.DeleteSchemaGeodatabase(schema_gdb)
DeleteSchemaGeodatabase example 2 (stand-alone 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 = "usr/connections/land@ora11204.sde"
# Process: Delete Schema Geodatabase
arcpy.management.DeleteSchemaGeodatabase(schema_gdb)
Environments
Current Workspace
Licensing information
Basic: No
Standard: Yes
Advanced: Yes