RE: Exports > 2GB -- need scripts

From: <Winnie_Liu_at_infonet.com>
Date: Fri, 17 Nov 2000 14:30:00 -0800
Message-Id: <10683.122433@fatcity.com>

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:

Subject: RE: Exports > 2GB -- need scripts

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

--

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

--

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