On Mar 30, 3:23 am, Christoph Krempe <c..._at_ub.fu-berlin.de> wrote:
> Hi,
>
> is it possible to change a multifile-TS (20 files of 2GB) to a bigfile-TS
> in Oracle9/10 WITHOUT EXPORT/IMPORT?
>
> Thanks,
>
> Christoph
If you have 2 times the used space in the tablespace available, then
it can be done. Create a new tablespace (REORG) and move tables or
rebuild indexes into the REORG tablespace. Drop the original
tablespace and then re-create it as a bigfile tablespace. Move tables
and rebuild indexes as needed back into the original tablespace.
Since REORG is now empty, you can reduce the size back down to
something more reasonable or drop it. Depending on your oracle
version, you may be able to do it all online. I would suggest using
dynamic SQL to generate your move/rebuild statements by querying
dba_tables/dba_indexes. Take care with tables containing clobs.
Received on Fri Mar 30 2007 - 11:37:40 CDT
