XML Index XDB.XDB$ACL_XIDX is in INPROGRS State and Fails to Drop with ORA-29868

(Doc ID 1103704.1)

Last updated on APRIL 16, 2015

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Jun-2012***

Symptoms


When running catnoqm.sql to deinstall XDB, dropping the XDB user fails with the error below:

drop user xdb cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-29868: cannot issue DDL on a domain index marked as LOADING

The index it is complaining about is the XDB.XDB$ACL_XIDX index which has a status of INPROGRS:

select owner, index_name, index_type, status
from dba_indexes
where owner = 'XDB' and status <> 'VALID';

OWNER   INDEX_NAME           INDEX_TYPE                                STATUS
----------- ----------------------- ------------------------------------- --------------
XDB         XDB$ACL_XIDX        FUNCTION-BASED DOMAIN    INPROGRS

Attempting to drop the index with the force option also fails with the same error:

SQL> drop index XDB.XDB$ACL_XIDX force;
drop index XDB.XDB$ACL_XIDX force
*
ERROR at line 1:
ORA-29868: cannot issue DDL on a domain index marked as LOADING

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms