Re: incremental import/export

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

It should still be viable in 10g. Although oracle is promoting and for good reason usage of the datapump import and export all the "good old" functionality import and export provided will still be around for a long time.

It's been a real long time since I used the incremental stuff but yes as you noted it works in conjunction with the full parameter. The posssible values that INCTYPE can have are COMPLETE CUMULATIVE and INCREMENTAL. Received on Mon Jan 15 2007 - 12:10:32 CST