Re: ALter table move on IOT - TOP

Robert wrote:

> 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
>

Definitely move it: Move it all. But please don't get into the mythology that separate tablespaces for tables and indexes have anything to do with anything beyond ease of maintenance. That vampire has had a stake through its heart for quite some time and doesn't need to be resurrected. Killing it a dozen times a year should be enough.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)