| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
