Index using SYS_MAKEXML - how do I get usable DDL?
Hi AllI need to migrate a 10.2.0.5 database on Solaris to 11.2.0.3 on Linux. This database has a large amount of XML data, with weird indexes. I've managed to recreate the tables, but there are a lot of indexes like this one.
CREATE UNIQUE INDEX "BOBB"."MYINDEX" ON "BOBB"."MYTABLE" ("SYS"."XMLTYPE"."GETSTRINGVAL"("SYS"."XMLTYPE"."EXTRACT"(SYS_MAKEXML('7F670EDF9228017FE0440003BA33F659',207984,"SYS_NC00062$","SYS_NC00065$"),'//PEGAWORKS/WorksCaseID')))
PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
When I try and create the index on the new database I get
CREATE UNIQUE INDEX "BOBB"."MYINDEX" ON "BOBB"."MYTABLE" ("SYS"."XMLTYPE"."GETSTRINGVAL"("SYS"."XMLTYPE"."EXTRACT"(SYS_MAKEXML('7F670EDF9228017FE0440003BA33F659',207984,"SYS_NC00062$","SYS_NC00065$"),'//PEGAWORKS/WorksCaseID')))
PCTFREE 10 INITRANS 2 MAXTRANS 167 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
When I try and create the index on the new database I get
0