perform a real time replication

Hi,
for just 3 table the bedst is snapshot (materialized viwes) and you can do it every hour (if there is a updating in tables) så snap shot log is not to big and don't take a few sek. or min. .
If it's more than 3 tables (200 or 300)it's better do look for tools that reading from redo log file (very expensiv)

Please provide more details on that and also a suggestion including DDL/DML syntax.

ok first create a link between to database go to destination database and say
create snapshot on
  "name for destination view you want"
refresh fast
  start with sysdate
  next sysdate + 1/1440
as select * from !" your table"@"remote_link"

look at here
http://www.dba-oracle.com/art_mv.htm

thanks.
please provide some more details on how to create remote_link between databases

ok do like tht start sqlplus in database you want snapshot
CREATE PUBLIC DATABASE LINK "your database with table"
 USING 'name for database with snapshot';

>>perform a real time replication

Snapshots/materialized views are not real-time.

You can also read up on Oracle's Advanced Replication (Single-Master).  I would really look into Oracle Streams Replication.  I'm not sure if Streams can be configured as one-way or not.

Before you ask:
>>Please provide more details on that

There is no single way to set this up.  Every installation is based on the specific requirements.   You need to understand the technologies and how to leverage them for your specific needs.

I'll refer you to the online documentation:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10705/toc.htm
http://download.oracle.com/docs/cd/E11882_01/server.112/e10706/toc.htm

slightwv: My reqirement is,

We have a need to perform a real time replication of three tables between two remote instances.

It is really one-to-one replication where the same tables exist on both, master and single slave, sites.

I was thinking of using materialized views, however looking for your recommendations.

Please provide a suggestion including DDL/DML syntax.

How to perform step-by-step materialized views replication and also for Streams.

slightwv:
Please give me step-by-step configuration deails relate with how to replicate tables between two remote instances with help of Database Stream.

Please provide a suggestion including DDL/DML syntax.

>>Please give me step-by-step configuration deails

I already commented on that before you asked.  Every replicated setup is different and there is no 'script' that can handle it.  You need to understand your requiremetns and what each of the options offers.  You then need to tailor the setup to your specific needs.

You'll need to go to the documentation to figure out how to set it up for your location.

Actually We have a need to perform a real time replication of three tables between two remote instances.
Please help me out how to configure Synchronous Replication (real-time). for replicating these tables.

ok