Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Exports > 2GB -- need scripts

Exports > 2GB -- need scripts

From: <cemail_at_sprintmail.com>
Date: Fri, 17 Nov 2000 10:25:03 -0800
Message-Id: <10683.122398@fatcity.com>


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! Received on Fri Nov 17 2000 - 12:25:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US