Toad World® Forums

Error during RE of index in 10g


#1

I’m not sure what support you plan for XML and Oracle Text, but I got the following error when reverse engineering a 10g schema:
Error during creation of index “ABC_XML_INDEX”. Attribute “SYS_NC00004$” has not been found.

The following script creates a set of objects that will reproduce the problem.

Rodney

CREATE TABLE abc (abc_id INTEGER PRIMARY KEY)
/

CREATE VIEW abc_xml OF XMLType WITH OBJECT ID
(extract (OBJECT_VALUE, ‘/abc/@abc_id’).getnumberval())
AS SELECT XMLElement (“abc”, XMLAttributes (abc_id AS “abc_id”))
FROM abc
/

CREATE MATERIALIZED VIEW mv_abc_xml AS SELECT * from abc_xml
/

CREATE INDEX abc_xml_index
ON mv_abc_xml (SYS_NC_ROWINFO$)
INDEXTYPE IS ctxsys.context
/


#2

Hello Rodney,

For now, Materialized View is not supported in TDM BETA.
In any case, such an error should not occur in next BETA release. (CR # 28 279).

Thanks for your help and patience!

Vladka & TDM Team