I am having a hard time finding the information I need and am hoping you all can help.
I am using sql developer and I have a database named us that holds 5 tables and a database named uk that holds the same 5 tables.
It is a demo online store with an item, client, order, orderdetails, and staff tables.
I want to set up replication so that at 11:59pm every night, anything added on the uk database is replicated to the us database.
Can someone please help me with the code to do this? I have everything else working great but replication information is fuzzy to say the least.
Thank you in advance