Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, %D0%A1%D0%B5%D1%80%D0%B3%D0%B5%D0%B8%CC%86.

Asked: January 26, 2018 - 2:19 am UTC

Last updated: January 27, 2018 - 2:20 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi!

I have a problem with XDB.XMLIndex. First of all, I create table:

CREATE TABLE DBF_LOG_TST (
  DBF_HEADER   CLOB,
  DBF_DATA     XMLTYPE
)
XMLType COLUMN DBF_DATA
        STORE AS BASICFILE CLOB
(TABLESPACE LOB
STORAGE (INITIAL 64 K
         MAXEXTENTS UNLIMITED));


then I create index
CREATE INDEX IDX_DBF_LOG_DocumentElement ON DBF_LOG_TST(DBF_DATA) 
  INDEXTYPE IS XDB.XMLIndex
  PARAMETERS ('paths (include (/DocumentElement/table))');


From application server, I send request with big xml data and save them into the table.
After that I select data from DBF_DATA field and some times get an error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE. Of couse at first I drop index with force key, then create again index or not drop index and only rebuild. But get this error again and again, onсe a week. Help please, for what reasons does this error occur?



and Chris said...

There's a bug in 11.2 which causes this, so you may be hitting it.

There's a patch available for it, see details in MOS note 1404559.1. It's fixed in 12.1.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

%D0%A1%D0%B5%D1%80%D0%B3%D0%B5%D0%B8%CC%86 %D0%A3%D1%81%D1%82%D0%B8%D0%BD%D0%BE%D0%B2, January 26, 2018 - 6:49 pm UTC

Thanks a lot!!! Very help me :-)
Connor McDonald
January 27, 2018 - 2:20 am UTC

Glad we could help

More to Explore

Design

New to good database design? Check out Chris Saxon's full fundamentals class.