I have index SYS_IOT_TOP_4459336 which needs to be moved by moving its associated table. Well, the table is AQ$_WF_BPEL_QTAB_T. How do I go about moving this? It has no associated segment as a table and I don't know how to rebuild the IOT. These have to be moved to a new tablespace as the old one is being dropped. Any help is appreciated. Thank you.! Oracle Version 10.2
Also, I have an overflow, SYS_IOT_OVER_2853366 which has IOT_NAME AQ$_ASO_ORDER_FEEDBACK_T_G. Can it be moved by alter table """ move overflow tablespace ...??