RE: Moving tables into new tablespace

Oracle doc´s says how you can move tables from one tablespace to another. Look at the export -import help.
You must export tables, delete it, asign quota cero on the onder tablespaces and then change the default tablespace
of the user you will import tables....

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.
>
> Also, is there a way to know how much % of the space used by an index is
> actually being used (equivalent to tables's dba_tables.empty_blocks)
>
> Can someone help?
>
> Thanx
>
>
Received on Wed Jun 28 2000 - 00:00:00 CDT