Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cumulative versus incremental export
You are confusing FULL=Y (which only takes the whole database) and INCTYPE=,
which determines which set of changes to export/
Look at the following scenario
Suppose you take a FULL, COMPLETE export on Monday. (FULL=Y,
INCTYPE=COMPLETE)
On Tuesday you take an INCREMENTAL (FULL=Y, INCTYPE=INCREMENTAL). This will
contain all that changed between the two exports.
On Wednesday you take another incremental. This will contain anything that
changed between Tuesday and Wednesday.
On Thursday you take a cumulative, (FULL=Y, INCTYPE=CUMULATIVE). This will
contain ALL changes from the last complete export, so everything between
Monday and Thursday.
And so on...
Hth,
--
Sybrand Bakker, Oracle DBA
Mourad Othman <mourad.othman_at_stusta.mhn.de> wrote in message
news:383EFACF.506763E0_at_stusta.mhn.de...
> I cannot make the difference between cumulative and incremental mode of
> exporting (FULL=Y), and when to use the one or/and the other. Can we
> say, that a complete export has the baseline level 0, cumulative the
> level 1, and that the incremental is of level 2 and it is a ministep of
> cumulative. Is that the main/only difference between them ?
> thanks for every help.
>
Received on Fri Nov 26 1999 - 23:59:18 CST