Re: Moving table to another tablespace

By the way,

there may be triggers, constraints ..., foreign keys with "delete cascade ..". Don't forget to check it before you drop tables or before you import tables in an existing schema !!!

TurkBear wrote:
>
> 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 Aug 04 1998 - 05:45:44 CDT