DBMS_PART package provides an interface for maintenance and management operations on partitioned objects.
Oracle Database Reference for related views
This chapter contains the following topics:
Gathers the list of global indexes where optimized asynchronous index maintenance has taken place to clean up entries pointing to data segments that no longer exist
Cleans up failed online move operations
As a consequence of prior partition maintenance operations with asynchronous global index maintenance, global indexes can contain entries pointing to data segments that no longer exist. These stale index rows will not cause any correctness issues or corruptions during any operation on the table or index, whether these are queries, DMLs, DDLs or analyze. This procedure will identify and cleanup these global indexes to ensure efficiency in terms of storage and performance.
DBMS_PART.CLEANUP_GIDX ( schema_name_in IN VARCHAR2 DEFAULT NULL, table_name_in IN VARCHAR2 DEFAULT NULL);
There are many possible points of failure when performing
ALTER TABLE ... MOVE PARTITION ... ONLINE operations. This procedure pro-actively cleans up such failed online move operations instead of waiting for the background process (
SMON) to do so.
DBMS_PART.CLEANUP_ONLINE_OP ( schema_name IN VARCHAR2 DEFAULT NULL, table_name IN VARCHAR2 DEFAULT NULL, partition_name IN VARCHAR2 DEFAULT NULL);
partition_name are specified, this cleans up the failed online move operation for the specified partition.
table_name are specified, this cleans up all failed online move operations for all the partitions of the specified table.
schema_name is specified, this cleans up all failed online move operations in the schema.
If no arguments are provided, we cleans up all the failed online move operations in the system.
All other cases raise
ORA-20000 to inform the user of invalid inputs as arguments.