Re: 2Gbyte datafile limit? Oracle 7.3.4

  Problem Description:

  Ora-27039 trying to add a datafile > 2 gig on IBM machine.

  Other possible scenario: Ora-27039 trying to add a datafile > 4 gig after   applying patch 620063 (which fixed the problem for datafiles > 2 gig).

  Other possible scenario: Ora-27039 trying to add a datafile > 4 gig after   applying patch 637360 and then upgrading to AIX 4.3.

  Other possible errors: ora-7244 ora-1578

  Problem Explanation:

  27039, 00000, "create file failed, file size limit reached"   // *Cause: an attempt was made to create a file that exceeds the process's
  // file size limit, additional information indicates which function
  // encountered the error
  // *Action: raise the file size limit

  Oracle and IBM support datafiles up to 64 gig on 4.2.1. Patch 620063 was   originally created to facilitate files > 2 gig but is insufficient for   datafles >= 4 gig. Patch 637360 supercedes 620063, allowing datafiles > 4 gig

  .

"Marco De Benedetto" <debe_at_galliera.it> wrote in message news:38505AA2.FAE2E637_at_galliera.it...
> I cannot create datafiles > 2G on AIX 4.3.2
>
> But it is not a system limit (such as filesystem or ulimit)
> because the user oracle can create files bigger than 2G (e.g. with dd)
>
> Is it an Oracle (7.3.4) limit?
>
> thanks
>
> Marco De Benedetto
Received on Thu Dec 09 1999 - 23:04:54 CST