I have about 20 tables and yes it is just the Customer data. BUT, one is intranet and the other is local, only at time of connect. The local app is on a laptop with a local db and may be used while not being connected while the intranet app is being used by someone else. Then at a point in time I want to connect the laptop and sync the two dbs at that time.
Both apps are identical, both db structures are identical, just syncing data between the two.
I know I'd have to create some business rules too, like which DML has priority over the other.
B

I am using the free EX version and have no licenses, that is why I was asking about PL/SQL code.
This is an app I am trying to use myself that maybe one day, if I complete it I could sell it. I'm trying to keep it free at first though.

1- Create a Database Link (DB Link) for example LAPTOP (for the database which is at LAPTOP and PC for the Database which is on PC)
2- write insert statements for example you're using laptop and then use the statement

INSERT into tble
select * from tble@PC;

or

MERGE statement

3- You can make an SQL script which will contain the insert statments for all the tables at your PC database and when you'll execute it at the LAPTOP then all the tables will be up synch.

or

You can include all these INSERT or MERGE statements in a PL/SQL procedure when you'll execute that at the LAPTOP database then this will be synch with the PC database.

Two apps, two DBs, one on intranet, one on laptop. Both are identical.
I run the one on the laptop while no internet available. Others may be changing data while I am off line on the intranet app.
Each table has a column LAST_UPDATED - I was thinking to process all NEW records first, easy just an INSERT. All updates and deletes WHERE LT.LAST_UPDATE = IT.LAST_UPDATE no problem, all that have different LAST_UPDATED could be prompted in my APEX app screen, like Outlook does while syncing.
??????????????

No, I was asking for an existing script being used somewhere just to give me a head start on my own script.
I use to work for an outfit that the DBA team had a team library of scripts for about everything u could think of, including this topic, but it was a secure environment and a long time ago so I haven't ask them or know who to ask.
Thank you, Bill

This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.

This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines