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:

Re:

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 16 Apr 2004 21:28:59 -0700
Message-ID: <1082176127.979440@yasure>


ITAPORT06 wrote:

> Oracle 8.1.7.4 WINNT NTFS
>
> I have a datafile of 2.4 GB.
> I have read articles about max size of a datafile. It is still not
> clear to me what is safe or not.
>
> I have the idea to create an aditional datafile
> Data file 1 (Which currently 2.4GB )Bring it back to 2GB
> Data file 2 (New) 2.GB
>
> Resizing I want to do by export - drop user - import (shall I make use
> of compress?
>
> The current datafile has increase unlimited. In the new situation I
> want to make Data file 1 max 2GB and the additional Data file 2
> Unlimited (in case of)
> Does this make any sense or not or should I forget resizing of the
> datafile and let it grow till 4 GB
> Thanks

You are not focused on the target.
If you can build it
And you can back it up
Leave it alone.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Apr 16 2004 - 23:28:59 CDT

Original text of this message

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