Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

is it possible to import, only changes since last import using imp/impdp

686394Nov 6 2009 — edited Nov 7 2009
on our production environment, we export three times a day.(10.00AM,1.00PM,6:30PM)

and We only want to import the evening export - we have to kind of make sure that if the online system fails _ we have a data up to yesterday evening.

i.e. we want a sort of incremental import, for example we would have yesterday's evening import and today we only want to import all the changes since yesterday's evenings import - that means we want to import into existing database but we want to import only the changes since last import.

it would be great to hear from you

the database is 10g R1

thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2009
Added on Nov 6 2009
6 comments
587 views