RE: Incremental Export in Oracle 9i
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Jun 2004 11:35:29 -0500
Hamid
If you are thinking that incremental export would just export the new
rows in a table. It doesn't. It just detects tables that have changed since
the last export and exports those tables.
As Joe points out, RMAN can do incremental backups, but you must have
Enterprise Edition and run in archivelogmode.
If you want just part of a table, you could do something better on your
own. Since 8i export has a parameter QUERY. If you have a timestamp column
for when a table is inserted or updated, then you could do a partial export
of the table for just the new or changed rows. Again, I have done exports
with the QUERY parameter, but haven't designed an incremental backup system
based on that.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hamid Alavi
Sent: Friday, June 04, 2004 11:19 AM
To: 'Oracle-L (E-mail)
Subject: Incremental Export in Oracle 9i
List,
Yesterday somebody from list told me that we don't have Incremental Export
any more in Oracle 9i, any idea what's the option we could use instead of
this?
Any better feature?
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
