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

From: <Deepender.Gupta_at_newpower.com>
Date: Wed, 27 Feb 2002 14:52:36 -0800
Message-ID: <F001.0041A7BE.20020227145236@fatcity.com>

Hi Rachel,
Thanks for the reply but can you explain "substitute the filenames you need for <logfile> and the other files" I have tried with the
cat file1 file2 file3 | zcat > /home/oracle/dkg/imp/imp_pipe & also.
I think the log file name doesn't have any meaning.

Regds
deepender

                                                                                                                                      
                                                                                                                                      
                                                       To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>              
                                                       cc:                                                                            
                                                       Subject:      Re: Import from a dump which was split and compressed while      
                                                             export.                                                                  
           Rachel Carmichael <wisernet100_at_yahoo.com>                                                                                  
                     02/27/02     05:30 PM                                                                                            
                  Please respond to ORACLE-L                                                                                          
                                                                                                                                      
           ------------------------------------------

what did you use to do the IMPORT?
this is what I've used on sun solaris after doing a similar export. you'll need to substitute the filenames you need for <logfile> and the other files

#!/bin/sh
mkfifo wrkpipe
umask 000

#
# start the reader from the import pipe
#

imp "/" file=wrkpipe full=y commit=y buffer=4096000 LOG=<logfile> &

#
# create the import stream coming from the pipes
#

cat <file1> <file2> | uncompress | dd of=wrkpipe

#
# clean up the import pipe
#

rm wrkpipe
--- Deepender.Gupta_at_newpower.com wrote:
>
> 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).

Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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).




-- 
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:52:36 CST