Re: Moving table to another tablespace

TurkBear,

I notice that the other replies suggested using export/import I would re-suggest the method you allude to only with the trick

create table different_name
as (select * from original_name)
tablespace new_tabspace;

This moves all the data at the same time as creating the new table. drop the original_name table
and rename the different_name table to original_name

This method is much much faster than the export/import method!!

TurkBear wrote in message <35bcaaa3.10192696_at_news2.mm.com>...
>Hi,
>What is the best way to move a table ( or several tables) from one
>tablespace to another? I would like to avoid the obvious - creating
>the table structure in the new tablespace with a different name, and
>using 'insert into....' statements to populate it with the data from
>the original table, dropping the original and renaming the new one....
>
>Any other way?
>
>Thanks,
>John Greco
>System : Oracle 7.3, Netware 4.11
>
>Reply here or email to : john.greco_at_dot.state.mn.us
>
>Thanks....
Received on Mon Aug 03 1998 - 01:44:07 CDT