Re: Error Exporting File

From: <rspeaker_at_my-deja.com>
Date: Thu, 24 Jun 1999 17:47:58 GMT
Message-ID: <7ktr0a$cft$1@nnrp1.deja.com>

you don't mention what operating system platform you are on, but have you checked to see if the oracle user is constrained by OS-imposed filesize limits, such as the unix ulimit?

In article <37724867.E6AEB6AC_at_mars-systems.com>,   Joe Condle <condle_at_mars-systems.com> 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 Thu Jun 24 1999 - 12:47:58 CDT