Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error Exporting File

Re: Error Exporting File

From: OraSaurus <granaman_at_not_home.com>
Date: Fri, 25 Jun 1999 03:25:38 GMT
Message-ID: <SECc3.1151$4p2.1162@news.rdc1.ne.home.com>


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

Received on Thu Jun 24 1999 - 22:25:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US