Re: max datafile size

From: Mike Jay <mikejay_at_mitre.org>
Date: Thu, 08 Nov 2001 10:46:56 -0500
Message-ID: <3BEAA8F0.E252934F@mitre.org>

Raymond,

Great article.

When it says "less than 2G" with respect to the MAXSIZE limit, where can I find a good number. Oracle Manual on Concepts? Tuning? Reference?

The article implies that if I put "MAXSIZE 2000M" that I will actual break the 2G datafile size limit. What is the header size of which the article speaks?

Thanks,
mikejay

Raymond wrote:
>
> From metalink:
>
> Introduction
> ~~~~~~~~~~~~
> This article describes "2Gb" issues. It gives information on why 2Gb is a
> magical number and outlines the issues you need to know about if you are
> considering using Oracle with files larger than 2Gb in size. It also
> looks at some other file related limits and issues.
> Eg: CORE is not used for SQL*Loader input file I/O

<snip> Received on Thu Nov 08 2001 - 09:46:56 CST