Using incremental exports
Export has the ability to perform three levels of exports: full, cumulative, and incremental. This is similar to the approach used by operating system backup utilities. You specify which level you are selecting via the INCTYPE parameter. See Chapter 16, for more information on how to specify export parameters.
Warning
Oracle has announced that it is dropping support for incremental and cumulative exports effective December 31, 1999.
To select the type of export, specify one of the following keywords as the value of INCTYPE:
- FULL
Processes all objects in the database.
- CUMULATIVE
Processes all objects modified since the last cumulative or full export.
- INCREMENTAL
Processes all objects modified since the last export.
In cumulative and incremental exports, the entire table is exported even if only one row has changed. In Oracle8, individual partitions in a partitioned table can be separately exported.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access