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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!