Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: change multifile-tablespace
On Mar 30, 9: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
Simply: No, as you can't make sure where the tables are created. Also you need to bear in mind usually a datafile is the smallest unit of recovery. What is going to happen if you need to recover 40 Gb?
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Mar 30 2007 - 03:12:19 CDT