RE: Exports > 2GB -- need scripts

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-----
From: ddorr.cs_at_clearstream.com [mailto:ddorr.cs_at_clearstream.com] Sent: Monday, November 20, 2000 3:40 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Exports > 2GB -- need scripts

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