Moving IOT's for AQADM

Hi guys,

I am doing some rearranging of a 9i database (9.2.0.4, but will be upgraded shortly to 9.2.0.6) on AIX 5.2. I have 5 objects in a tablespace that needs to be dropped, so I want to move them to a different tablespace. They are all owned by AQADM and cannot be moved using typical alter table move and alter index rebuild.

Any one have any ideas? This is currently being done with a disposable/test database, but will need to be done soon with a production copy.

Thanks

Stephen

OWNER        SEGMENT_NAME                    PARTI SEGMENT_TYPE         MBy=

------------ ------------------------------- ----- --------------- --------=
---
AQADM        SYS_IOT_TOP_16133                     INDEX                  4=


.00

AQADM        SYS_IOT_TOP_16135                     INDEX                192=


.00

AQADM        SYS_IOT_TOP_16137                     INDEX                  4=


.00

AQADM        SYS_IOT_TOP_16140                     INDEX                124=


.00

AQADM        SYS_IOT_OVER_16137                    TABLE                  4=

--
http://www.freelists.org/webpage/oracle-l