System generated LOB type indexes
38646Jul 6 2005 — edited Jul 21 2005Oracle10g: if you create a table w/a column type SDO_GEOMETRY, Oracle automatically generates 2 LOB type indexes per this column data type & place them in the user's default tablespace (e.g. USERS).
1. How do you specify in the "create table..." stmt that these 2 indexes be placed in other tablespace, e.g. INDX_TS?
2. How do you relocate these existing 2 indexes from tablespace USERS to tablespace INDX_TS? Note: Oracle doesn't allow "alter index ... rebuild tablespace INDX_TS" for these LOB type indexes, it even doesn't allow you to drop these existing LOB type indexes.