cancel
Showing results for 
Search instead for 
Did you mean: 

How to retrieve Updated records only from Database???

Former Member
0 Kudos

Hi,

I have created data in Oracle DB

and send that from Oracle to File server today

and next day some changes have been made to some records

Now i want to send those Updated Records only to File server

How to acieve this

Regards

Suman

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Suman,

you have two possibilities:

a) delete processes records

b) flag records as "processed". For this you need a dedicated field in your DB-table.

Regards Mario

GabrielSagaya
Active Contributor
0 Kudos

please check the link

http://wiki.oracle.com/thread/1246329/findrecentmostrowsaddedinatable?t=anon

Here you can find the new inserted data/ modified data from a table.

Former Member
0 Kudos

Hi,

For this type of Requirement Can we do any thing in XI???

Or it needs to be take on Oracle DB side only???

Regards

Suman

Former Member
0 Kudos

Good question ... If the table was not designed to reflect such records (thru a last_changed_date, or has_changed flag etc) it will be hard to get'em

Chris

Former Member
0 Kudos

Hi,

Can you please Elloborate more on this???

Regards

Suman