Oracle trigger updating table in another server -
let's suppose i'm using 2 oracle servers, server , b server, located different nations. have same schema, called a-bay, , table, called user_data. finally, have same table rows because want customers able use both site.
so, want use "trigger" updating data in server when customers change personal information in b server, vice versa.
what should do? if using mysql, use federated engine can't use in case.
moreover, servers don't support golden gate!
Comments
Post a Comment