Xref: alice comp.databases.oracle.server:77536
Path: alice!news-feed.fnsi.net!netnews.com!newsswitch.lcs.mit.edu!newsfeed.mathworks.com!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: "Charles Hansis" <chansis@earthlink.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: 2Gbyte datafile limit? Oracle 7.3.4
Date: Sun, 12 Dec 1999 20:39:07 -0500
References: <38505AA2.FAE2E637@galliera.it>
X-Posted-Path-Was: not-for-mail
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-ELN-Date: 13 Dec 1999 01:33:55 GMT
X-ELN-Insert-Date: Sun Dec 12 17:35:13 1999
Organization: EarthLink Network, Inc.
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MSMail-Priority: Normal
Lines: 26
Reply-To: "Charles Hansis" <chansis@earthlink.net>
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@galliera.it> wrote in message
news:38505AA2.FAE2E637@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