Re:

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)