That's fine Rachel,
>
> I agree with you . But the problem is that when I do the import , import
> goes fine till the first split file and it hangs only at a particular
> position. I am doubting that when It switch from one split file to the
> second split file it gives error. meaning which some junk character are
> written at the end of split file.
>
Thanks,
Deepender
[EMAIL PROTECTED]
914 697 2169(work)
914 671 3113(cell)
To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Import from a
dump which was split and compressed while
export.
Rachel Carmichael <[EMAIL PROTECTED]>
02/27/02 06:18 PM
Please respond to ORACLE-L
------------------------------------------
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
--- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> cc:
>
> Subject:
> Re: Import from a dump which was split and compressed while
> export.
>
> Rachel Carmichael <[EMAIL PROTECTED]>
>
> 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
> --- [EMAIL PROTECTED] 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@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
> >
> > [EMAIL PROTECTED]
> > 914 697 2169(work)
> > 914 671 3113(cell)
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
