I was asked to perform synchronization between Oracle and Access. Lets say if I added or updated any data in Oracle, at the same time the Access database will update the same changes too. The sync should be made in real-time, no intervals. Before this, I thought that database links and database synchronize are the same thing, but I was wrong. I have tried integrating Oracle and Access using database link, but my idea was rejected by my colleague, saying that sync and link are different.
Could anyone please suggest me anything to synchronize these databases? Does synchronizing involve any triggers or stored procedure?
Oh please I've been looking for the answer for a week :'(