Re: Error Exporting File

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
Received on Thu Jun 24 1999 - 10:36:35 CDT