Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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=tes
------------ ------------------------------- ----- --------------- --------= --- 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-lReceived on Mon May 23 2005 - 13:23:44 CDT
![]() |
![]() |