Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Domain index marked unusable when running GATHER_TABLE_STATS

759514Jun 28 2011 — edited Jan 17 2013
I've recently discovered that I am unable to insert rows that contain a XMLTYPE column with a XMLIndex when I'm running the DBMS_STATS.GATHER_TABLE_STATS procedure:
BEGIN
    DBMS_STATS.GATHER_TABLE_STATS ( OWNNAME => '"MY_NAME"', TABNAME => '"MY_TABLE"', estimate_percent => 35 );
END;
It will fail with the following error msg:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
Does this mean that gathering stats on the XMLIndex will always make the index unusable during the stats gathering procedure and thus, no inserts can be done on the table during this time? (XMLIndex is the only domain index on my table)

Banner info:
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0  Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production    

Comments

mwrf
resolved, just being stupid.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 14 2013
Added on Jun 28 2011
8 comments
958 views