RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

I'd say file size limit/autoextend feature has been Oracle's dirty little secret for quite a while. For a very long period of time there was similar 4GB 'magic' barrier on Windows, that was allegedly fixed. Workaround for the problem was to create datafile 1 MB larger than the 'magic' number, and ether resize it using this trick or add another datafile to tablespace when the time comes (whenever MagicNumber or N x MagicNumber is close).

Despite rumours (of having fixed autoextend feature on Windows) I recently witnessed failed imports into Oracle 9.2.0.1.0 caused by too small tablespaces that just wouldn't autoextend. Interestingly, import died "beautifully" cuz silently in the middle of job without _any_ errors, traces etc. Just gone.

There is also interesting myth here at the place where I work that systems tablespace autoextend feature ain't to be trusted as "it is known" to have caused intermittent data dictionary corruptions while code recompilation takes place under space "crunch" conditions...  

On slightly cynical side note: autoextend that doesn't - maps nicely into job safety ;-)

Branimir

> -----Original Message-----
> From: Orr, Steve [mailto:[EMAIL PROTECTED]
> Sent: June 4, 2003 11:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ???
>
>
> I've just been informed that there is a 2GB datafile size
> limit with Oracle 8.1.7 on Linux... PERIOD. This despite the
> fact that we've had files in excess of this for some time and
> they work just fine. The problem occurs when the autoextend
> "feature" reaches the 2GB threshhold. Of course, Oracle
> didn't tell me this until after about 4 days of back and
> forth testing for them. (There is no such O/S file size
> limit.) I've reviewed the Linux release notes, the Linux
> install guide, the Linux admin guide and the contents of
> $ORACLE_HOME/relnotes and I don't find any such limitation in
> the documentation. Did I miss it? Can anyone find any such
> published limitation in the docs? Is this a secret?
>
>
> Peeved at Oracle... AGAIN,
> Steve Orr
> --
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).