Home » SQL & PL/SQL » SQL & PL/SQL » sql query (10g)
sql query [message #332030] Mon, 07 July 2008 05:16 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

Pelase find the following requirement.
Requirement -
 
There are 2 standalone database named database A and
database B used by 2 separate application. Database A 
has schema S1 and Database B has schema S2.
 
Schema S1 has around 40 master tables which get updated 
very frequently. This 40 tables are also present in S2 
also. 
 
We want the both the 40 tables to be in sync every 
hourly or half any hour. 
 
eg. If records are added/updated deleted in S1.emp then 
same should be done in S2.emp and visa versa also.
 
We dont want to use dblink,materialised views or 
scripts. Is there any feature in Oracle 10G like 
replication or Streams where in this can be done.
 
Incase if are not able to replicate both ways then at 
least one way can we replicate ? like any records are 
added/updated deleted in S1.emp then same should be done 
in S2.emp and similarly in the other 39 tables.
 



Thank you
Re: sql query [message #332041 is a reply to message #332030] Mon, 07 July 2008 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
We dont want to use dblink,materialised views or
scripts. Is there any feature in Oracle 10G like
replication or Streams where in this can be done.

The 2 are in contradiction, both replication (that is mviews) and Streams use db links.

Regards
Michel
Re: sql query [message #332043 is a reply to message #332041] Mon, 07 July 2008 05:52 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Why you wan't to reinvent the wheel.

Oracle has already provided you the feature.Then why you do not want to do it that way.

Regards,
Rajat Ratewal
Previous Topic: LOV/ Foreign values
Next Topic: Commit data in several databases
Goto Forum:
  


Current Time: Sun Dec 04 12:40:31 CST 2016

Total time taken to generate the page: 0.08198 seconds