how to name xmltype column index
In Oracle 11g, the following command creates a table with a single XMLTYPE column.
CREATE TABLE EMPLOYEE
(
XMLTYPE details
);
Oracle will create an index called something like SYS_IL0000211081C00005$$ automatically for the column without me doing anything else. I presume this is because it's stored as a LOB behind the scenes.
Does anyone know how I can specify the name of the index when the column is created as opposed to leaving it to Oracle ? I need to control my index names for assisting schema comparisons.
Thanks in advance
Andy