Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error Exporting File
Check your OS size limits and your users ulimit. Most systems have an
"absolute" limit of 2 GB (not 2.1! Remeber, 2*1024**3 != 2,000,000,000!).
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