Home » RDBMS Server » Server Utilities » export crisis..!!!
export crisis..!!! [message #140042] Fri, 30 September 2005 10:12 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
we used to take daily backup using exp/imp utility.
yesterday the export process terminated leaving error as follows

EXP-00030: Unexpected End-Of-File encountered while reading input
. . exporting table CLMMCDerror closing export file (null)
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully


we have the filesize of 2g with 50 export files specified ...what might be the problem behind this ..??

shall we increase the filesize value more than 2g ...?

plz advice...

regards
bala

Report message to a moderator

Re: export crisis..!!! [message #140047 is a reply to message #140042] Fri, 30 September 2005 10:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first, export is not a backup method.
it seems that, your have reached some filesystem limitation.
If your OS is limiting the filesize with 2g, then you may want to split the files.
If you are already exporting into multiple files then
add another file in your export command line.

Report message to a moderator

Re: export crisis..!!! [message #140050 is a reply to message #140047] Fri, 30 September 2005 10:32 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems your case.
http://www.orafaq.com/forum/t/51120/0/

Report message to a moderator

Previous Topic: SQL*Load with concatenation
Next Topic: sql loader question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:00:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.