you might want to consider rerunning the export then
- Deepender.Gupta_at_newpower.com 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
>
> 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
> #
> 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
>
=== 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: 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 - 18:23:19 CST