Oracle | DBMS

Oracle DBMS_PART Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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	DBMS_UTILITY	PLITBLM

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-20000	No global index segments were cleaned
ORA-44001	Invalid schema

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmspart.sql

Subprograms

CLEANUP_GIDX

CLEANUP_GIDX_INTERNAL

CLEANUP_ONLINE_OP

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, spelling is correct in 21c as shown below

      

      exec dbms_part.cleanup_gidx(USER);

      

      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 global index segments were cleaned

      ORA-06512: at "SYS.DBMS_PART", line 226

      ORA-06512: at "SYS.DBMS_PART", line 291

      ORA-06512: at line 1

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);

      

      PL/SQL procedure successfully completed.