RE: Moving tables into new tablespace

From: Juan Álvarez <jalvarez_at_edisa.es>
Date: 2000/06/29
Message-ID: <8jfoip$5as72@SGI3651ef0.iddeo.es>#1/1

Syltrem <syltrem_at_videotron.ca> escribió en el mensaje de noticias dw865.6056$LX4.120655_at_weber.videotron.net...
> Hi!
>
> I want to move some tables from one tablespace to another and I don't know
> what's the best way to do it.
>
> I want to make sure my indexes and other constraints will follow.

TOAD has a 'Rebuild table' option to do things like that, basically, it locks the table, renames to table_x, creates a new table with the original name and populates it,

It has also an 'Index size estimation' utility.

Dani, Received on Thu Jun 29 2000 - 00:00:00 CDT