I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI.
Can somebody explain me way to do this (Both databases are not identical).
I have an idea like selecting required row data from first table and putting it in generic temp table. And then using DBLINK inserting the same to the second database.
Do anybody have any nice and easy way to do the same.
Thanks in advance.