The two tables is not A network segment, has been achieved by DBLINK two tables connected, have to do now is if you have new data is inserted into A table. A table B how to achieve real-time updates? Of new know only can use the trigger, but can trigger words written in table B, how to write? Daniel help sprout new!!!!!!

CodePudding user response:

You can write directly in A
Also can use Oracle ha flow replication table level synchronization

CodePudding user response:

Can consider materialized views

CodePudding user response:

Both upstairs to
Materialized view
If can consider to dblink outside, and table A and table B, did you do any special transformation, then we can use logical synchronization tools, such as flow copy (not recommended, already out), goldengate, this kind of tools on the market is still A lot

CodePudding user response:

Or again, like the ESB push, also can consider, look at the specific business scenarios, not necessarily at the database level to realize

CodePudding user response:

Across servers, had better not use the trigger, or network once disconnected, your production system, the paper wrong

CodePudding user response:

If just two simple table set up an ogg is the most simple and rapid