Oracle 11g on Linux
I'm trying to move an IOT to a different tablespace. I've moved the table via ALTER TABLE <table> MOVE TABLESPACE <new tablespce>, but there is an associated 'primary key' index (index type is 'IOT - TOP'). I'm trying to move this primary key, but ALTER INDEX <idx> REBUILD TABLESPACE <new tablespace> gives me an error that IOT primary keys cannot be rebuilt and ALTER TABLE <iot table> MOVE; doesn't seem to have any affect (with or without the ONLINE argument). Nor can I drop the PK and re-add it. (Note the test environment I'm working on is air gaped from the workstation I'm using to get on this site, so I can't just copy/paste requested results, but I can transcribe short segments). Any suggestions on how I can move or rebuild the IOT - TOP index on the new tablespace?
Jim Wolfe