moving IOT index to new tablespace
anand_gpFeb 11 2011 — edited Feb 11 2011Aim was to shrink datafile and got "ORA-03297: file contains used data beyond requested RESIZE value". Datafile size 7GB but used 128MB.
So created new Tablespace and moved all tables and index partitions to new TS.
Now I see some entries in USER_INDEXES, which I need to move to new TS. But they are IOT's.
INDEX_NAME INDEX_TYPE TABLE_OWNER TABLE_NAME
SYS_IOT_TOP_1082946 IOT - TOP DSI_DPIPE SYS_IOT_TRNS_1082943
SYS_IOT_TOP_1082949 IOT - TOP DSI_DPIPE SYS_IOT_TRNS_162982
I don't know how to move these indexes to new TS. Please help.
Thanks,
-Anand