is it possible to import, only changes since last import using imp/impdp
686394Nov 6 2009 — edited Nov 7 2009on 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