Re: Max Size Datafile in 10g

1. 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"

------------------------------------------------------------