473,398 Members | 2,120 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

Prcedural replication issue

Hello ,
Oracle 9.0.1.0.0 on HP-UX 11.11

I am testing Procedural Replication in Multimaster Replication
Environment. (Asynchronous)

Package PACK_1 with a PROC_1 does insert in TAB_1. The procedure does
a simple insert in tab_1.
I mark PACK_1,PROC_1 for replication (Multimaster replication)

After starting replication , I execute procedure

execute proc_1 on Inst_1

But somehow this execution is not captured by replication & hence does
not fire on inst_2 which is second master site. I cannot see inserted
row in second instance.

AM I missing something ? I cld not find details on Procedural
Replication in manual except saying procedures need to be part of
package .

The reason I am looking at Procedural Repl is that I have many tables
which do not have primary key . So I cannnot use table level
replication for those tables.

Any help/pointers in this regad are highly appreciated ....

Thanks & Regards,
Mahesh Hardikar
Jul 19 '05 #1
0 1652

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ian Wyld | last post by:
Hello All We intend to replicate a database in order to have it as a near immediate standby in case of the failure of the main server. Is this the best solution for disaster recovery? We...
5
by: johnm | last post by:
Here is my situation. We run a very mission critical application that uses DB2 7.2 for the data repository. The database is hosed at a data center in Los Angeles, Ca. Our main office...
4
by: Andi Plotsky | last post by:
I need to synchronize 3 databases (1 Master and 2 replicas). I thought I'd give the Replica feature in Access2000 a whirl. I'm not sure I'm THAT impressed.....but maybe I'm just doing something...
3
by: dlesandrini | last post by:
I need advice about my decision to go with Replication in general. This post was placed on the Microsoft Replication newsgroup, but I really value the feedback that comes from this group as well. ...
9
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4...
6
by: Alex | last post by:
Hello, We are currently running our Access 2003 database over Citrix. We have been using a single front-end, but reading over topics in this group has made it clear that I should create...
2
by: Query Builder | last post by:
I have a wired situation..! I set up transactional replication on one of my development server (SQL 2000 Dev Edition with sp4). It is running fine without any issues and all of a sudden, i...
2
by: Query Builder | last post by:
Hi, I have transactional replication set up on on of our MS SQL 2000 (SP4) Std Edition database server Because of an unfortunate scenario, I had to restore one of the publication databases. I...
0
by: Mahesh Hardikar | last post by:
Hello , Oracle 9.0.1.0.0 on HP-UX 11.11 I am testing Procedural Replication in Multimaster Replication Environment. (Asynchronous) Package PACK_1 with a PROC_1 does insert in TAB_1. The...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.