Re: 2Gbyte datafile limit? Oracle 7.3.4

From: Charles Hansis <chansis_at_earthlink.net>
Date: Sun, 12 Dec 1999 20:39:07 -0500
Message-ID: <831ie3$bdi$1@oak.prod.itd.earthlink.net>

Yes it is, I had the same problem recently on an HP server with large filesystems enabled. It wasn't HPUX giving the error, it was Oracle. We called Oracle and they forwarded us a copy of a document that gave instructions on "fooling" Oracle into writing to a "file" and performing a dd from that file to the actual export file. There are other ways of handling this limitation though, you could use a split command ( I saw that someone had posted a script on this earlier).

Good Luck.
JH

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 Sun Dec 12 1999 - 19:39:07 CST