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.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
