Re: incremental import/export

Charles Hooper wrote:
> ehilah wrote:
> > Is incremental import/export supported on oracle 10g ?
> > I found no ref in documentation but if I launch exp help=y i can see
> > inctype parameter. I don't want to use it but a customer asked me about
> > that function.
> > I remember that it worked only with full export, is it correct ? and I
> > remember that for importing you have to import first the full import and
> > then the incremental database, is it correct ?
> > I remember even that you can import instead only a table for the
> > incremental export because for any table modified in the incremental you
> > find drop and recreate istruction and then all the data. Is all this
> > correct ?
> > thanks in advance
> > Pier Paolo
>
> Documentation references to incremental export:
> http://www.oracle.com/pls/db102/search?remark=quick_search&word=incremental+export
>
> I seem to recall that incremental export is being depreciated.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

A review of my 10gR2 Utilities manual does not show the parameter and a serach of the documentation turned this up:

EXP-00041: INCTYPE parameter is obsolete Cause: Export encountered the INCTYPE parameter when parsing Export options. Incremental Exports are no longer supported. Action: Consult the Oracle Backup and Recovery guide. Export will attempt to continue.

I would advise the customer that the feature was never useful on an active system since if even one row in a table changed the entire table was exported is no longer supported, even if the feature still works on your
version/platform, suggest a different export backup strategy that can be supported going forward.

Also make sure the customer is not confusing incremental exports with rman incremental hot backups.

HTH -- Mark D Powell -- Received on Mon Jan 15 2007 - 09:13:12 CST