ORA-29861: maintenance tasks
Hello,
we have such a table in 11g SE One:
CREATE TABLE CORE."TRANSACTIONS_MODELS" (
"Y" NUMBER NOT NULL, "M" NUMBER NOT NULL, "D" NUMBER NOT NULL, "CNT" NUMBER NOT NULL,
"REVISION" INTEGER NOT NULL,
"MODELS" XMLTYPE NOT NULL,
PRIMARY KEY (y,m,d,cnt,"REVISION") VALIDATE,
FOREIGN KEY (y,m,d,cnt) REFERENCES CORE."TRANSACTIONS" (y,m,d,cnt) DISABLE NOVALIDATE
) XMLType COLUMN "MODELS" STORE AS SECUREFILE CLOB ( TABLESPACE TMODELS ) TABLESPACE TMODELS;
CREATE INDEX CORE."TRANSACTIONS_MODELS_IX" ON CORE."TRANSACTIONS_MODELS" V (MODELS) INDEXTYPE IS XDB.XMLINDEX;
Once in a while we cannot insert data into this table due to ORA-29861:
CREATE TABLE CORE."TRANSACTIONS_MODELS" (
"Y" NUMBER NOT NULL, "M" NUMBER NOT NULL, "D" NUMBER NOT NULL, "CNT" NUMBER NOT NULL,
"REVISION" INTEGER NOT NULL,
"MODELS" XMLTYPE NOT NULL,
PRIMARY KEY (y,m,d,cnt,"REVISION") VALIDATE,
FOREIGN KEY (y,m,d,cnt) REFERENCES CORE."TRANSACTIONS" (y,m,d,cnt) DISABLE NOVALIDATE
) XMLType COLUMN "MODELS" STORE AS SECUREFILE CLOB ( TABLESPACE TMODELS ) TABLESPACE TMODELS;
CREATE INDEX CORE."TRANSACTIONS_MODELS_IX" ON CORE."TRANSACTIONS_MODELS" V (MODELS) INDEXTYPE IS XDB.XMLINDEX;
Once in a while we cannot insert data into this table due to ORA-29861:
0