Skip to Main Content

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!

moving IOT index to new tablespace

anand_gpFeb 11 2011 — edited Feb 11 2011
Aim 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2011
Added on Feb 11 2011
13 comments
3,081 views