| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
| Pragmas |
SUPPLEMENTAL_LOG_DATA(default, NONE); |
| Security Model |
Owned by SYS with EXECUTE granted to PUBLIC |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmspart.sql
{ORACLE_HOME}/rdbms/admin/prvtpart.plb |
| Subprograms |
|
| |
| CLEANUP_GIDX |
| Undocumented |
dbms_part.cleanup_gidx(
schema_name_in IN VARCHAR2 DEFAULT NULL,
table_name_in IN VARCHAR2 DEFAULT NULL,
parallel IN VARCHAR2 DEFAULT '0'
options IN VARCHAR2 DEFAULT
'CLEANUP ORPHANS'); |
exec dbms_part.cleanup_gidx;
*
ORA-20000: No global index segments were cleaned
exec dbms_part.cleanup_gidx(NULL, 'SALES');
*
ORA-44001: invalid schema |
| |
| CLEANUP_GIDX_JOB |
| Undocumented |
dbms_part.cleanup_gidx_job(
parallel IN VARCHAR2 DEFAULT '0',
options IN VARCHAR2 DEFAULT 'CLEANUP_ORPHANS'); |
conn sys@pdbdev as sysdba
exec dbms_part.cleanup_gidx_job('0', 'CLEANUP_ORPHANS');
PL/SQL procedure successfully completed. |
| |
| 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. |