Re: Moving IOT overflow tablespace ?

Statements of the form

    alter table XXX
    move overflow tablespace new_tablespace     nologging
    ;

used to work in 8.1.5. Which version are you running.

--
Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




Winner Manurung wrote in message ...


>Hi all,

>Does any body know how to move overflow segment of IOT

>separated from data segment ?

>I've tried several alter table move ... overflow ...   statements,

>but both segments move to the (data) tablespace.

>

>TIA,

>Winner

>

>

>

>

>

>

>

>