Re: Moving table to another tablespace

Use export. 'grep' (or equiv. on your platform) the 'CREATE TABLE' statements out from the export dump to a file and alter there tablespace definitions. Run the script to create the tables. Do an import of the data with ignore=y.

MotoX.

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 Tue Jul 28 1998 - 02:01:32 CDT