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