try to remove recordlength param and retry...
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 27 Feb 2002 14:02:12 -0800
Hi All,
The compressed dump export file size of my database is more than 2 gb
and my OS file size limitation is 2 Gb so I compressed and
split it into two parts while export. While export I got is
"export terminated successfully without warning" but at the time of
import, after successfully importing few tables it
gave me the following errors at the end.
IMP - 00009 uncompress: 0653-059 The input file contains bad data;
SIGSEGV signal received.
and I could not import the data from it.
Script used for Export is as :
mknod /home/oracle/exp_pipe p
compress < /home/oracle/exp_pipe | split -b1023m -
/home/oracle/dmps/EXPORT. &
_______________________________________________________________________________________________________________
The script for the import I used was
mknod /home/oracle/dkg/imp/imp_pipe p
cat /test3/test/EXPORT* | zcat > /home/oracle/dkg/imp/imp_pipe &
sleep 20
imp username/passwd@TEST file=/home/oracle/dkg/imp/imp_pipe
log=/home/oracle/imp/imp.log buffer=117376000
recordlength=64000 fromuser=username touser=username
ignore=y
___________________________________________________________________
Kindly suggest where I am wrong.
Why the import terminates after successfully impoting of few tables
Thanks,
Deepender
[EMAIL PROTECTED]
914 697 2169(work)
914 671 3113(cell)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
MOHAMMAD RAFIQ
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
