Oracle DBMS_PART
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Support for partitioned tables with APIs for management and maintenance activities
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DBMS_STANDARD INDEX_ORPHANED_ENTRY_V$
DBMS_PART_LIB    
Documented Yes
First Available 12.1.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmspart.sql
Subprograms
 
CLEANUP_GIDX
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 dbms_part.cleanup_gidx(
schema_name_in IN VARCHAR2 DEFAULT NULL,
table_name_in  IN VARCHAR2 DEFAULT NULL);
exec dbms_part.cleanup_gidx;
*
ERROR at line 1:
ORA-20000: No gloabl index segments were cleaned
ORA-06512: at "SYS.DBMS_PART", line 139
ORA-06512: at "SYS.DBMS_PART", line 193
ORA-06512: at line 1

-- SR 3-7561290501 submitted for misspelling.

exec dbms_part.cleanup_gidx('SH');

exec dbms_part.cleanup_gidx(NULL, 'SALES');

exec dbms_part.cleanup_gidx('SH', 'SALES');
 
CLEANUP_GIDX_INTERNAL
Undocumented but appears to be the core code called by CLEANUP_GIDX only having additional granularity.
dbms_part.cleanup_gidx_internal(
schema_name_in  IN VARCHAR2 DEFAULT NULL,
table_name_in   IN VARCHAR2 DEFAULT NULL,
orphans_only_in IN INTEGER  DEFAULT 1,
noop_ok_in      IN NUMBER);
conn sys@pdbdev as sysdba

exec dbms_part.cleanup_gidx('SH', 'SALES', 0);
*
ERROR at line 1:
ORA-20000: No gloabl index segments were cleaned
ORA-06512: at "SYS.DBMS_PART", line 139
ORA-06512: at "SYS.DBMS_PART", line 193
ORA-06512: at line 1

-- SR 3-7561290501 submitted for misspelling.
 
CLEANUP_ONLINE_OP
Clean up failed online move operations
dbms_part.cleanup_online_op(
schema_name    IN VARCHAR2 DEFAULT NULL,
table_name     IN VARCHAR2 DEFAULT NULL,
partition_name IN VARCHAR2 DEFAULT NULL);
exec dbms_part.cleanup_online_op(USER);

Related Topics
DBMS_I_INDEX_UTL
DBMS_INDEX_UTL
DBMS_PCLXUTIL
Indexes
Packages
Partitioned Tables and Indexes
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved