logfile is so you can SEE the results of the import
if file1 file2 file3 are the names of the files you created with the
split and export then you use those.
for example, suppose the files you created were named firstexportfile
and secondexportfile and you want to record the output of the import in
a file named importlogfile
you would cd to the directory where firstexportfile and
secondexportfile are.
create a shell script (called splitimport.sh) with the following lines
in it and then run the shell script. I would suggest you read up on
Unix commands as well. For what it's worth, the way to do this is
documented in a note on MetaLink. I don't have the exact reference but
you can search for it
#!/bin/sh
mkfifo wrkpipe
umask 000
#
# start the reader from the import pipe
#
imp "/" file=wrkpipe full=y commit=y buffer=4096000 LOG=importlogfile &
#
# create the import stream coming from the pipes
#
cat firstexportfile secondexportfile | uncompress | dd of=wrkpipe
#
# clean up the import pipe
#
rm wrkpipe
- Deepender.Gupta_at_newpower.com wrote:
>
> 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).
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 - 17:18:27 CST
