Delete Schema Geodatabase (Data Management)

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

LabelExplanationData 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

LabelExplanationData Type
Updated Input Workspace

The updated input workspace.

Workspace

arcpy.management.DeleteSchemaGeodatabase(input_database)
NameExplanationData 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

NameExplanationData 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

Related topics