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

1. Limit imposed by filesystem/Veritas. That stuff is OS dependant - you ask the OS/filesystem/cfs vendor.
2. Limit imposed by Oracle. Those values are provided in Appendix A of the "Reference" manual found at http://docs.oracle.com The Installation guide, specifically the pre-install checklist chapter, discusses the settings in more detail for OSs.