| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Import from a dump which was split and compressed while export.
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
deepender.gupta_at_newpower.com
914 697 2169(work)
914 671 3113(cell)
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 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 #
# # create the import stream coming from the pipes #
# # clean up the import pipe #
>
> >
> > 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).
-- 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 - 17:58:18 CST
 |
 |