Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ALter table move on IOT - TOP

Re: ALter table move on IOT - TOP

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 02 Dec 2003 23:07:05 +0000
Message-ID: <si6qsv497fld19s2si84socep4gmb17kjr@4ax.com>


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 (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Received on Tue Dec 02 2003 - 17:07:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US