My Oracle Support Banner

orphan entry exists after partition maintenance operation (Doc ID 2289005.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

After partition maintenance operation orphan index entries found in index view

Changes

Entry before partition maintenance operation

SQL> select index_name, orphaned_entries
2 from ind
3 where table_name='T';

INDEX_NAME ORP
------------------------------ ---
T_NAME_I NO

Entry after partition maintenance operation

SQL> alter table t move partition for('X') online update indexes tablespace
tc_small_quota;
alter table t move partition for('X') online update indexes tablespace
tc_small_quota
*
ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'TC_SMALL_QUOTA'

Elapsed: 00:00:00.37
SQL> select index_name, orphaned_entries
2 from ind
3 where table_name='T';

INDEX_NAME ORP
------------------------------ ---
T_NAME_I YES

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.