Re: incremental export

From: Cameron Abbott <cvabbott_at_altavista.com>
Date: Fri, 9 Nov 2001 15:32:56 -0500
Message-ID: <9shee5$se7$1@bcarh8ab.ca.nortel.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a7eout05h7nutdkv8phucdhigup28tkrq0_at_4ax.com...
> On Fri, 9 Nov 2001 13:03:45 -0500, "Cameron Abbott"
> <cvabbott_at_altavista.com> wrote:
>
> >If I do an incremental export today and then tonight another export is
done
> >as part of a cron, not incremantal. Then tomorrow I do another
incremental
> >export, will it be smart enough to go back to the incremental export I
did
> >today or will it only go back to the cronned export that runns tonight?
> >
> >Thanks
> >
> The latter. The default inctype=complete and by default all exports
> are recorded.

---

Even if inctype is not specified. According to the Oracle Server Utilities manual : COMPLETE "Exports all objects and updates the tables SYS.INCEXP and SYS.INCVID. (A full=Y export does not update these tables unless you specify the INCTYPE parameter)"

The manual also says "INCTYPE Default: none" in the section Export parameters.

---

> The Oracle Server Utilities manual has a discussion on this. It also
> designing an robust incremental scheme.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Nov 09 2001 - 14:32:56 CST