Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: change multifile-tablespace

Re: change multifile-tablespace

From: sybrandb <sybrandb_at_gmail.com>
Date: 30 Mar 2007 01:12:19 -0700
Message-ID: <1175242339.345047.318840@p77g2000hsh.googlegroups.com>


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 DBA
Received on Fri Mar 30 2007 - 03:12:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US