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

From: <Deepender.Gupta_at_newpower.com>
Date: Wed, 27 Feb 2002 14:02:12 -0800
Message-ID: <F001.0041A60F.20020227140212@fatcity.com>

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). Received on Wed Feb 27 2002 - 16:02:12 CST