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.
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”))
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