Re: ALter table move on IOT - TOP

On Tue, 02 Dec 2003 22:04:19 +0100, Robert <cookie - remove - @tref.nl> wrote:

>I don;t hav any experience with IOT's

http://otn.oracle.com/pls/db92/db92.vbook?search=index-organized+table&remark=VBook+hint

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

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tables.htm#18769

-- 
Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)