I am sorry I added the mail since i forgot to remove it.
here is the script for importing
#. /opt/app/oracle/oracle_env
#. /opt/app/oracle/dba_env
ORACLE_SID=BLINKH
export ORACLE_SID
cd $EXPORT_DIR
#
# create filenames for the parts of the backup... for now let's go to 3
#
FILENAME1=$EXPORT_DIR/backup1_$ORACLE_SID.dmp
FILENAME2=$EXPORT_DIR/backup2_$ORACLE_SID.dmp
FILENAME3=$EXPORT_DIR/backup3_$ORACLE_SID.dmp
LOGFILE=$EXPORT_DIR/backup_$ORACLE_SID.log
#
# create the pipe to import from
#
mkfifo wrkpipe
umask 000
#
# start the reader from the import pipe
#
imp "/" file=wrkpipe full=N FrOMUSER=BILLING GRANTS=N TOUSER=BILLING
INDEXES=N IGNORE=Y commit=y
buffer=4096000 LOG=$LOGFILE &
#
# create the import stream coming from the pipes
#
cat $FILENAME1 $FILENAME2 $FILENAME3 | uncompress | dd of=wrkpipe
#
# clean up the import pipe
#
rm wrkpipe
>From: "Wang, Linda" <lwang_at_messagemedia.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Exports > 2GB -- need scripts
>Date: Mon, 20 Nov 2000 12:55:55 -0800
>
>How to import them?
>
>-----Original Message-----
>Sent: Monday, November 20, 2000 1:01 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Use the below said script in your shell script it will export files greater
>than 2 gb.
>
>echo "FULL EXPORT OF BLINK ON FOX HAS STARTED" |mailx 8774472907_at_skytel.com
>. /export/home/oracle/aruns_data/oracle_env
>ORACLE_SID=BLINK
>export ORACLE_SID
>cd $EXPORT_DIR
>#
># set maximum file size for each chunk of the export file
>#
>MAXFILESIZE=2000m
>export MAXFILESIZE
>#
># create filenames for the parts of the backup... for now let's go to 3
>#
>FILENAME1=$EXPORT_DIR/fullexport/backup1_$ORACLE_SID.dmp
>FILENAME2=$EXPORT_DIR/fullexport/backup2_$ORACLE_SID.dmp
>FILENAME3=$EXPORT_DIR/fullexport/backup3_$ORACLE_SID.dmp
>LOGFILE=$LOGS/backup_$ORACLE_SID.log
>#
>#
># create the pipes
>#
>mkfifo exportpipeaa
>mkfifo exportpipeab
>mkfifo exportpipeac
>mkfifo wrkpipe
>umask 000
>#
># start the readers from the pipes to create the export files
>#
>dd if=exportpipeaa of=$FILENAME1 &
>dd if=exportpipeab of=$FILENAME2 &
>dd if=exportpipeac of=$FILENAME3 &
>#
># start the reader from the wrkpipe to compress and split the export
>#
>dd if=wrkpipe|compress|split -b $MAXFILESIZE - exportpipe &
>#
># start the export for real
>#
>exp "/" file=wrkpipe full=y compress=n buffer=4096000 LOG=$LOGFILE
>#
># clean up after ourselves
>#
>rm exportpipeaa exportpipeab exportpipeac wrkpipe
>#
># if you haven't used all the pipes, the dd may still linger on
># make sure to REALLY clean up
>#
>ps -ef|grep exportpipe|grep -vi grep|awk '{printf ("kill -9 %d;
>\n",$2)}'>kill.lst
>chmod u+x kill.lst
>sh kill.lst
>rm kill.lst
>echo "FULL EXPORT OF BLINK ON FOX IS COMPLETE" |mailx 8774472907_at_skytel.com
>-------------------------------
>
>
>
>
> >From: "Wang, Linda" <lwang_at_messagemedia.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: Exports > 2GB -- need scripts
> >Date: Mon, 20 Nov 2000 08:30:28 -0800
> >
> >Compress and split the exported file on the fly looks fine.
> >But when I tried to uncompress and combine those split
> >files on the fly, only the first compressed file was
> >uncompressed. -Linda
> >
> >-----Original Message-----
> >Sent: Monday, November 20, 2000 3:40 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >compress < exp_pipe | split -b2048m - <name> &
> >
> > > ----------
> > > From: Allan Davis Sahadeo[SMTP:asahadeo_at_neal-and-massy.com]
> > > Reply To: ORACLE-L_at_fatcity.com
> > > Sent: Sunday, November 19, 2000 22:10
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Exports > 2GB -- need scripts
> > >
> > > Thanks Winnie,
> > > But is there a way to combine both compressing and splitting? This
> >script
> > > only splits but doesn't compress.Is there a way to do both on the fly
>?
> > > Allan.
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Friday, November 17, 2000 6:30 PM
> > >
> > >
> > > >
> > > >
> > > > This is how you spilt the files if the compresses form of export >
>2GB
> > > >
> > > > for export:
> > > >
> > > > mknod /tmp/exp_pipe p
> > > > cd <to the directory where you want to put the split file>
> > > > split -b2047m < /tmp/exp_pipe &
> > > > exp user/pwd file=/tmp/exp_pipe <other options>
> > > >
> > > > Winnie
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Rajendran, Srini" <SRAJENDRAN_at_nlfs.com>@fatcity.com on 11/17/2000
> > > 01:54:40
> > > > PM
> > > >
> > > > Please respond to ORACLE-L_at_fatcity.com
> > > >
> > > > Sent by: root_at_fatcity.com
> > > >
> > > >
> > > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > > cc:
> > > >
> > > >
> > > >
> > > > if you are running oracle 8i, you can specify multiple files as dump
> > > > destination.
> > > >
> > > > -----Original Message-----
> > > > Sent: Friday, November 17, 2000 4:23 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > I was wondering, if the size of the compressed file did exceed 2
>gigs
> > > then
> > > > we would indeed be in a bit of a predicament. Since an export does
> > > compress
> > > > fairly nicely, we may not encounter such a problem. But what if we
> > > did...
> > > > What would we do then ? Do we split our compressed files ? And if so
> >how
> > > do
> > > > we ?
> > > > Allan.
> > > > ----- Original Message -----
> > > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > > Sent: Friday, November 17, 2000 4:50 PM
> > > >
> > > >
> > > > Here are the scripts for export and import:
> > > >
> > > > For export:
> > > > mknod t1.dmp p
> > > > compress < t1.dmp> t10.dmp.Z &
> > > > exp us/pw parfile=exp.dat
> > > >
> > > > For Import:
> > > > /etc/mknod t1.dmp p
> > > > dd of=t10.dmp if=t1.dmp &
> > > > imp us/pw parfile=imp.dat
> > > >
> > > > Ramani
> > > > DBA
> > > >
> > > > >>> <cemail_at_sprintmail.com> 11/17/00 01:25PM >>>
> > > >
> > > > I have a 45GB Oracle 8.0.5 database on HPUX. I want to be able
> > > > to do nightly exports so that if any of the tables gets
>"accidentally"
> > > > truncated or whatever, we can restore just the table and not
> > > > have to restore the entire database.
> > > >
> > > > Does anybody have a script that uses the split(?) utility and
> > > > compress so that the export isn't bigger than 2GB? What about
> > > > importing? Can just one table be picked out of that large of
> > > > an export if the export is split up and compressed? Please let
> > > > me know your experience/advice on doing this.
> > > >
> > > > -----
> > > > Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> > > > The FREE way to access your mailbox via any web browser, anywhere!
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author:
> > > > INET: cemail_at_sprintmail.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: Akhil Ramani
> > > > INET: Akhil.Ramani_at_3cc.co.wayne.mi.us
> > > >
> > > > 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: Allan Davis Sahadeo
> > > > INET: asahadeo_at_neal-and-massy.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: Rajendran, Srini
> > > > INET: SRAJENDRAN_at_nlfs.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: Winnie_Liu_at_infonet.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: Allan Davis Sahadeo
> > > INET: asahadeo_at_neal-and-massy.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: ddorr.cs_at_clearstream.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: Wang, Linda
> > INET: lwang_at_messagemedia.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).
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: ARUN K C
> INET: arun_k_c_at_hotmail.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: Wang, Linda
> INET: lwang_at_messagemedia.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
Received on Mon Nov 20 2000 - 22:06:39 CST
