This discussion is archived
2 Replies Latest reply: Sep 6, 2012 12:27 PM by Srini Chavali-Oracle RSS

How to move IOT of AQ table

960474 Newbie
Currently Being Moderated
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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points