Re: Moving tables into new tablespace

Ah! Sounds good! And where can I find TOAD?

Thanks

Juan Álvarez <jalvarez_at_edisa.es> wrote in message news:8jfoip$5as72_at_SGI3651ef0.iddeo.es...
>
> 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