exporting updated records only [message #70442] |
Fri, 14 June 2002 05:55 |
Henry
Messages: 14 Registered: November 2000
|
Junior Member |
|
|
Hi,
I would like to know whether it is possible to do export at table level; but only the updated records are exported since its last export.
Thanks
Henry
|
|
|
Re: exporting updated records only [message #70447 is a reply to message #70442] |
Fri, 14 June 2002 09:30 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
there is common workaround possible.
1. create a shadow table similiar to the target table.
2. write a trigger on the target table,that fires whenever there is an update for each row, and insert only the updated records into the shadow table.
3. export this shadow table which contains only the updated records.
|
|
|