Database Administration (MOSC)

MOSC Banner

ORA-00942 with ALTER TABLE <IOT_TABLE> MOVE ONLINE;

edited Dec 2, 2009 8:54AM in Database Administration (MOSC) 7 commentsAnswered
Hello,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center