1 Reply Latest reply: Sep 6, 2012 1:45 PM by damorgan RSS

    move AQ$ tables created as IOT

    960474
      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

      Edited by: user2412757 on Sep 6, 2012 9:55 AM