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
Thanks, it was driving me nuts as I thought I was doing something wrong in my uploading program.
AFAIK its an open enhancement request.
We have running into this issue which causes "outages" for a production client. Is this enhancement request taken care of in latest Oracle 11.2.0.x patchset? If not, can somebody give us the Oracle metalink note ID regarding this enhancement request?