Re: Error Exporting File

From: <rspeaker_at_my-deja.com>
Date: Fri, 25 Jun 1999 17:36:28 GMT
Message-ID: <7l0emr$ac2$1@nnrp1.deja.com>

sorry, should have mentioned I am running 8.0.5.1

In article <7l0dbg$9o7$1_at_nnrp1.deja.com>,   rspeaker_at_my-deja.com wrote:
> 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.
>

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