oracle 有 Incremental export的功能嗎

[watermelonyu]

聽說export 可以做到 Incremental

就是full export 之後,資料又異動了,export 可以只針對異動的部分在export 就好

請問怎做的?

[watermelonyu]

Hi Joey,

用"incremental export" 當做keyword

serach在Metalink上可以找到很多關於incremental export 的document.

Regards,

老鷹

[watermelonyu]

看是看了

但不是很懂

incremental export 是拿什麼做比較

才知道哪些是有異動過的



像是rman 因為所有的備份資料都會記錄在catalog db or control file

但是export 會有紀錄嗎,不然incremental export 怎知道哪些已經異動過了

[watermelonyu]

Hi Joey,

The incremental exports is a deprecated feature. It exports any table that has had one bit modified in it.



To use incremental or cumulative exports, you must start with a complete export.After that you can do incremental exports -- these will export any TABLE that has been modified since the last complete, incremental or cumulative export. It

exports the entire table -- not just changed rows.



A cumulative export will export all tables that have been modified since the last complete or cumulative export. Thanks.

老鷹