Moving a table from one tablespace to another tablespace

[Peter Jenny]

Hi NG

what is the easiest way to move a table from one tablespace to another ?

Thanks
Peter

[Daniel Roy]

Re: Moving a table from one tablespace to another tablespace

The answer is highly dependant on your version. If you have 8i at
least, just do "alter table yourtablename move (online) tablespace
newtablespace". Look in the SQL reference manual for all the options
you can use while doing this move.

Daniel

Hi NG
>
what is the easiest way to move a table from one tablespace to another ?
>
Thanks
Peter
>
--