Re: Error Exporting File

From: <rspeaker_at_my-deja.com>
Date: Fri, 25 Jun 1999 17:13:31 GMT
Message-ID: <7l0dbg$9o7$1@nnrp1.deja.com>

I don't believe that to be so, once I corrected my AIX ulimit, I was able to create and use files larger than 2 GB. I have a tablespace based on a 2500 MB datafile, and another on a 4000 MB file. Querying the dba_data_files for the 2500 MB file shows the BYTES column at 2621440000.

I would recommend having the S/A set the ulimit for the oracle user to '-1' which equates to unlimited.

HTH,
Roy

In article <37725083.4E68D370_at_csgsystems.com>,   Terry Ball <terry_ball_at_csgsystems.com> wrote:
> According to Oracle WWW, until Oracle 8.0.6, Oracle does not
> support files larger than 2G even if the OS does. A way around this
> is to compress on the fly, since Oracle can not check the size of the
> file which is being compressed.
>
> Terry Ball
> Sr. DBA, CSG Systems
>
> Joe Condle wrote:
>
> > When doing my weekly export of a very large table I get the
following
> > errors:
> >
> > Export done in WE8ISO8859P9 character set and WE8ISO8859P9 NCHAR
> > character set
> > Note: grants on tables/views/sequences/roles will not be exported
> > Note: indexes on tables will not be exported
> >
> > About to export specified tables via Direct Path ...
> > Current user changed to MARS
> > . . exporting table TRANSACTIONS
> >

........................................................................

...
> >

........................................................................

...
> >

........................................................................

...
> >

........................................................................

...
> >

........................................................................

...
> >

........................................................................

...
> > ......................................................
> > EXP-00002: error in writing to export file
> > EXP-00002: error in writing to export file
> > EXP-00000: Export terminated unsuccessfully
> >
> > The resulting export file is 2.1 gigabyte uncompressed. There is
> > plently of diskspace available. Why would I get getting error in
> > writing to export file? Any help would greatly be appreciated.
> >
> > Joseph P. Condle Jr. condle_at_mars-systems.com Office 412-648-
1379
> > Senior Systems Engineer Fax 412-647-
9661
> > Medical ARchival Systems, Inc. (MARS) Pager 412-572-
9490
> > 3500 Victoria Street Pgh. Pa. 15261 USA
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 25 1999 - 12:13:31 CDT