Re: Data file size in Oracle 8.1.7 for NT

Thanks for your advices, everyone!

It is true that I can just recreate the database if something goes wrong (the data in this development environment are not important, as they are backup of "the real" data). BUT - as 7 developers are depending on this database to be running to do their work, I am concerned about it not to "die a horrible death"..
And the 5 * 2G datafile is something I would like to avoid, as there are very large extents in the database that we copy from (so even though compress is set to NO there has been some problems related to this earlier). I have come to the conclusion that I will try using a 10G datafile, and if it does not work I will just be angry with Oracle software and rather use another database in my next project..

Thanks,
Randi Wølner

"Peter" <rman9i_at_yahoo.com> wrote in message news:z1qo8.200$f5.508095_at_mencken.net.nih.gov...
> I have a few 3G and one 4G datafile in my testing database (8.1.7 for
2000).
> I have no problems.
>
> "Randi Wølner" <randiwolner_at_hotmail.com> wrote in message
> news:a7sh27$svn$1_at_oslo-nntp.eunet.no...
> > I have earlier been warned against data file sizes larger than 2 G.
> > Right now I am just about to create a new database for a development
> > environment. There will never be taken any backup of the database, so it
> is
> > not necessary to take any precautions in file size regarding that
matter.
> > But - there will (often) be done import of a dump file, where some of
the
> > tables are very big - 1 - 1,5G. For all the tables to "fit in" I think
it
> > would be a good idea to have one large data file of 10 G instead of 5 of
2
> > G. Is that safe?? I think I heard sometime that there was a bug in some
> > (earlier) version of Oracle for NT that made it very risky to have data
> > files larger than 2G...
> >
> > Any experiences, ideas?
> >
> > Thanks,
> > Randi Wølner
> >
> >
>
>
Received on Thu Mar 28 2002 - 04:09:13 CST