you might want to consider rerunning the export then
--- [EMAIL PROTECTED] wrote: > > 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 > === message truncated === __________________________________________________ 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).
