Oracle replication

Hi everyone,

I'm want to implement a simple data replication between two tables located on two different oracle 10g databases. I appreciate any guidance on the easiest and fastest way to do that. Again i just want to replicate regular data between the two tables.

Thanks in advance.

Set up a dblink from master (A) to slave (B), then create a synonim in B of A's tables through dblink and create materialized views in B based on synonims.

Great you make its sound easy,

I'm actually in newbie in oracle. I would appreciate it if you can provide me with more details about that. A link maybe that talks about synonims and materialized view.

Thanks.

Can't you do a Google search????
Start reading http://srmwww.gov.bc.ca/gis/oratransfer.html and http://www.databasejournal.com/features/oracle/article.php/2192071

And of course right from the horse's mouth:

http://www.oracle.com/technology/documentation/index.html

Well i have lot of reading to do. Thanks guys !!

Hi everyone,

Pabloj, the method you mentioned to me for replicating data creates a materialized view on B. In my scenario i already have a table with the same fields as the table on A. This table has data. If i create this materialized view, does it act as a regular table. If that's the case i can get rid of the table i currently have, create the materialized view with the same name and then my application that uses the deleted table should run fine. Is that the case?
Can anyone tell me what's the difference between creating a db link and creating an entry in the tnsnames.ora.

Thanks..

If B only needs to read from that table you can use the mview and get rid of your original table.
Adding an entry in the tnsnames.ora is editing a text file, making the infos added available to oracle.
Adding a dblink is making a database aware of another one (another local instance or a remote one), an entry in the tnsnames is needed to build a dblink.

Hi,

I set up the materialized view with fast refresh. It was created successfully and all the data on the remote table were copied to the materialized view. The problem i'm having now is that when i add a new entry to the master table, it doesn't get reflected in the materialized view. I checked my master log and the new entry was written to it,
The Weird thing is that when i query the master table locally i get the new entry but when i do a query from the remote machine it doesn't reurn the new entry. I guess that's the problem.
One thing I created my db link under the public schema, and all my other tables and materialized view is created under a vipuser schema.

Thanks..

Hi Pabloj,

Well i figured out my problem. I had NEXT SYSDATE +1/48 and it was taking forever to replicate. I changed it to 1/(48*60) and the data get replicated fast . Thanks for everything.

Regards,

Moe

Did you check the "refresh fast on commit" option for your materialized view?

Hi,

I was using FAST START WITH SYSDATE option. I'll go ahead and change that to fast on commit.

Thanks