The Geodatabase Administration toolset contains tools for a variety of geodatabase management tasks. Specific geodatabase data management tools as well as geodatabase upgrade, management, and maintenance are covered by the tools in this toolset.
Updates database statistics of base tables, delta tables, and archive tables, along with the statistics on those tables' indexes. This tool is used in enterprise geodatabases to help get optimal performance from the RDBMS's query optimizer. Stale statistics can lead to poor geodatabase performance.
Establishes or changes user access privileges to the input enterprise geodatabase datasets, stand-alone feature classes, or tables.
Compresses an enterprise geodatabase by removing states not referenced by a version and redundant rows.
The Configure Geodatabase Log File Tables tool allows you to alter the type of log file tables used by an enterprise geodatabase to maintain lists of records cached by ArcGIS.
The Create Database User tool creates a database user with privileges sufficient to create data in the database.
The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user to act as the geodatabase administrator and owner of the geodatabase. Functionality varies depending on the database management system used. The tool grants the geodatabase administrator privileges required to create a geodatabase, and then creates a geodatabase in the database.
The Create Raster Typetool installs the ST_Raster data type in a geodatabase stored in Oracle, Microsoft SQL Server, or PostgreSQL.
The Create Role tool creates a database role and lets you add users to or remove users from the role.
The Delete Schema Geodatabasetool deletes a schema geodatabase from a master sde geodatabase in Oracle.
The Diagnose Version Metadatatool identifies inconsistencies within the system tables used to manage versions and states in a versioned geodatabase.
The Diagnose Version Tables tool identifies inconsistencies in the delta (A and D) tables of a versioned geodatabase.
The Enable Enterprise Geodatabase tool creates geodatabase system tables, stored procedures, functions, and types in an existing database, thereby enabling geodatabase functionality in the database.
The Export Geodatabase Configuration Keywordstool exports the configuration keywords, parameters, and values from the specified enterprise geodatabase to an editable file. Change parameter values or add custom configuration keywords to the file and use the Import Geodatabase Configuration Keywords tool to import the changes to the geodatabase.
The Import Geodatabase Configuration Keywordstool allows you to define data storage parameters for an enterprise geodatabase by importing a file containing configuration keywords, parameters, and values.
This tool is designed to change the data types used to store rasters in an enterprise geodatabase in Oracle, PostgreSQL, and SQL Server; geometries in geodatabases in Oracle and SQL Server; and BLOB objects in attribute columns in geodatabases in Oracle. This is done through the migration of raster, spatial, or BLOB objects using configuration keywords specified in the DBTUNE table.
This tool is used in databases and enterprise, workgroup, and desktop geodatabases to rebuild existing attribute or spatial indexes. In enterprise, workgroup, and desktop geodatabases, indexes can also be rebuilt on states and state_lineage geodatabase system tables and the delta tables of versioned datasets. Out-of-date indexes can lead to poor query performance.
Registers feature classes, tables, views, and raster layers that were created in the database using ArcGIS clients with the geodatabase. Once registered, information about the items—such as table and column names, spatial extent, and geometry type—is stored in the geodatabase's system tables, allowing these registered items to participate in geodatabase functionality.
The Repair Version Metadata tool repairs inconsistencies within the versioning system tables of a versioned geodatabase.
The Repair Version Tablestool repairs inconsistencies in the delta (A and D) tables of a versioned geodatabase.
Updates the ArcGIS for Server license in an enterprise geodatabase.
Upgrades the schema of a mosaic dataset, network dataset, or parcel fabric to the current ArcGIS release. Upgrading the dataset allows the dataset to make use of new functionality available in the current software release.
Upgrades a geodatabase to the latest ArcGIS release to take advantage of new functionality.
Upgrades a low precision dataset's spatial reference to high precision.