Oracle-L: Re: Import from a dump which was split and compressed while export.

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 27 Feb 2002 14:46:31 -0800
Message-ID: <F001.0041A746.20020227144631@fatcity.com>

try to remove recordlength param and retry...

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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_at_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

deepender.gupta_at_newpower.com
914 697 2169(work)
914 671 3113(cell)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: Deepender.Gupta_at_newpower.com

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: ListGuru_at_fatcity.com (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: rafiq9857_at_hotmail.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Feb 27 2002 - 16:46:31 CST