Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to name xmltype column index

Andy SteelNov 10 2008 — edited Nov 10 2008
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 8 2008
Added on Nov 10 2008
#11g, #column, #index, #table
4 comments
223 views