Re: Max Size Datafile in 10g

Connor,

Any idea how they managed to do is ? I guess the DBA increased in size for bigfile tablespaces ...

kind regards
K

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:4146F6E4.76F2_at_yahoo.com...
> A. Fuentes wrote:
> >
> > Hello Fellow Oracle Users,
> >
> > What is the maximum size of a datafile that Oracle 10g server
> > can support: a)In a Filesystem? b)In a Veritas Raw Volume?
> >
> > Would it be the maximum file size that the OS filesystem can support?
> >
> > Any info will be appreciated.
> >
> > Best,
> >
> > A. Fuentes
>
> bigfile tablespaces I think are limited to 8 exabytes. (8 million
> terabytes). Whether your OS can cope (or whether you have that much
> disk!) is another question
>
> hth
> connor
> --
> Connor McDonald
> Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
> ISBN: 1590592174
>
> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com
>
> Coming Soon! "Oracle Insight - Tales of the OakTable"
>
> "GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
> and...he will sit in a boat and drink beer all day"
>
> ------------------------------------------------------------
Received on Tue Sep 14 2004 - 10:05:34 CDT