8 Replies Latest reply on Jan 17, 2013 7:04 AM by Marco Gralike

    Domain index marked unusable when running GATHER_TABLE_STATS

      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:
          DBMS_STATS.GATHER_TABLE_STATS ( OWNNAME => '"MY_NAME"', TABNAME => '"MY_TABLE"', estimate_percent => 35 );
      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:
      Oracle Database 11g Enterprise Edition Release - 64bit Production
      PL/SQL Release - Production
      CORE  Production
      TNS for Linux: Version - Production
      NLSRTL Version - Production