Re: Hit 4GB file size limit in Oracle 9.2.0.1.0 on W2003
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Fri, 12 Dec 2008 17:18:37 -0600
Message-ID: <mhC0l.9479$Ei5.2508@flpi143.ffdc.sbc.com>
>
> I've encountered same error years ago. It is not a limit on 4GB but a
> problem
> with file autoextension on the exact size of 4GB. it is a very
> particular case if
> during autoextension datafiles reachs exactly 4 GB database became
> corrupted.
> If you extend manually directly to 5 GB it goes well. We installed at
> that time patchset 9.2.0.5.
>
> Regards,
> Cristian
Date: Fri, 12 Dec 2008 17:18:37 -0600
Message-ID: <mhC0l.9479$Ei5.2508@flpi143.ffdc.sbc.com>
Cristian Cudizio wrote:
> On 12 Dic, 11:52, stephenmor..._at_btinternet.com wrote:
>> Please could anybody help. A friend has a corrupted database. She >> has execeed 4GB on the size of a datafile. She has been told she will >> need patch 2585700 and will have to restore her database. I must >> admit I was not aware of this problem. >> >> I would be gratefull for any information, if anybody has experience of >> this problem. She want to be sure she is doing the right thing to >> solve the problem. >> >> Thanks in advance. >> >> Best wishes, Stephen.
>
> I've encountered same error years ago. It is not a limit on 4GB but a
> problem
> with file autoextension on the exact size of 4GB. it is a very
> particular case if
> during autoextension datafiles reachs exactly 4 GB database became
> corrupted.
> If you extend manually directly to 5 GB it goes well. We installed at
> that time patchset 9.2.0.5.
>
> Regards,
> Cristian
I guess this is what happens when companies fail to keep their systems updated... If she had been running 9.2.0.8 (the terminal release of 9i) she would have never seen it. Received on Fri Dec 12 2008 - 17:18:37 CST