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).
