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 -----
From: <Winnie_Liu_at_infonet.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, November 17, 2000 6:30 PM
Subject: RE: Exports > 2GB -- need scripts
>
>
> 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
Received on Sun Nov 19 2000 - 15:05:01 CST
