2 Replies Latest reply: Sep 6, 2012 2:27 PM by Srini Chavali-Oracle RSS

    How to move IOT of AQ table

      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 ...??

      thanks for all help