ORA-00942 with ALTER TABLE <IOT_TABLE> MOVE ONLINE;
I am running oracle 10.2.0.1 and trying to move an IOT table using the 'alter table ____ move online;' command. I'm running into an ORA-00942 error ('table or view does not exist'). I can see the IOT in the dba_indexes view with a 'IOT - TOP' index_type. If anyone has had this issue, what is the work-around?
Thank you,
Chris