ALter table move on IOT - TOP

Hi all,

I have an 8.1.7.4 DB.
The database holds a schema for a specific application. I recently inherited the administration off the instance. The guy who used to do it quit the job.

I saw he used some IOT table's (i'm not sure why, but that's another question).

After looking in the database it looks like he isn't the great DBA after all. He did create tablespaces for data and for indexes (even on seperate disks). But all schemas have SYSTEM as default and all tables ended up in the SYSTEM tablespace because the create statement for all tables didn't specify another tablespace.

I don;t hav any experience with IOT's
After looking up some docs i understand that it used a normal index organisation and a "overflow" tablespace. Seems OK.

But i couldn't find anything about moving IOT's. I would like to move the IOT out of SYSTEM.

Can i safely execute
alter table <table_name> move tablespace <tablespace_name> on the table's ??

What does oracle do with the overflow data ?

Thanks in advance,

Robert Received on Tue Dec 02 2003 - 15:04:19 CST