| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Exports > 2GB -- need scripts
Try this
Hope it helps
comp_pipe=/tmp/comp_pipe
rm $comp_pipe
mknod $comp_pipe p
chmod 777 $comp_pipe
nohup compress <$comp_pipe >/u01/app/oracle/admin/XXX/exp/XXX.`date +"%d%m%y"`.Z &
su oracle -c "exp system/password file=$comp_pipe full=y log=$log"
>
> 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).
Received on Fri Nov 17 2000 - 17:24:15 CST
 |
 |