Hi,
I newly setup master to master replication : I followed the steps. It is 9i so no need to run catrep:
1) Create replication administrator repadmin
2) Grant privileges and register repadminas propagator and receiver
3) Create public database links, private database link in repadmin.
4
current redo log file, then I
would suggest 9i Data Guard in maximum performance mode (or Standby in 8i)
solution over the MM replication. The DG solution does not affect the
primary database performance. You can backup the standby database and use it
for recovery of the primary, too.
If you can't
LG,
Is it possible to establish further downstream snapshot replication from a
snapshot site in 8.1.7.0.0/Solaris 2.8? I know this can be done in 8.1.7.4.x
and 9i and I can not build multi-master replication due to restrictions :-(
i.e. I'd like to perform: master -- snapshot (new master
Check for heterogenous services in Oracle
docs.
Tanel.
- Original Message -
From:
Nikhil Khimani
To: Multiple recipients of list ORACLE-L
Sent: Friday, November 28, 2003 9:49
PM
Subject: Oracle to MS-SQL
Replication
LG,
Any pointers,
white
LG,
Any pointers, white
papers, URL, etc.on how to replicate data from Oracle 8i/9i to
M$-SQL2K?
Many
thanks,
Nick Khimani
Verification was easy. We just powered down the primary machine, changed the
db name in the external table, drop the replication on the backup server and
restart the application. Everything worked fine. After 2-3 days, over the
weekend, we rebuilt the replication again.
Yechiel Adar
Mehish
We are doing exactly that. We use multi master synchronous replication. In
case the regular server dies, we drop replication from the backup machine.
Change one parameter in the application ini file (what db name to use in
connections), start the application again. About 5 minutes turn around time
Yechiel - So how do you verify your backup environment? My gut feeling is
that simpler systems are less prone to catastrophe, and multimaster
replication definitely adds a lot of pieces compared to conventional
backups.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message
Hello!
What do you think of additional backup method as multimaster replication?
Isn't it a way to continue working normal, if main database crash and I move
all connections to another master site?
--
Oracle 9i DBA beginner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
VirVit,
You haven't specified Oracle version and your tolerance for data loss. If
you can afford to lose the data in the most current redo log file, then I
would suggest 9i Data Guard in maximum performance mode (or Standby in 8i)
solution over the MM replication. The DG solution does not affect
Dear Gurus,
I have dbms_job in replication environment to push deffered transactions from site A
to B and B to A.
The job which is running at site A is working fine but job which is running at site
B is not pushing the transactions automatically. But if I do it manually (either
dbms_job.run
-L
[EMAIL PROTECTED]
Sent: Fri, 14 Nov 2003 05:29:30
Dear Gurus,
I have dbms_job in replication environment to push
deffered transactions from site A to B and B
to A.
The job which is running at site A is working
fine but job which is running at site B is not
pushing the transactions
(never
remember where it goes).
HTH
SF
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Fri, 14 Nov 2003 05:29:30
Dear Gurus,
I have dbms_job in replication environment to push
deffered transactions
by: [EMAIL PROTECTED]
11/05/2003 06:14 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:any problem rebuilding indexes used for replication
Hello,
I have to rebuild some primary key indexes due to excessive
multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA.
Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: any problem rebuilding indexes used for replication
Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes.
One script uses the table index_stats and looks
:
Subject:any problem rebuilding indexes used for replication
Hello,
I have to rebuild some primary key indexes due to excessive fragmentation.
It is rebuild not drop and create. We have multi master replication running.
Is there any problem to replication if I
problem rebuilding indexes used for replication
renu (and Jared),
The reason I'm very interested in whether there's performance improvement is
that there's a thread on the newsgroup about index rebuild recently. See
http://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO
:any problem rebuilding indexes used for replication
Hello,
I have to rebuild some primary key indexes due to excessive fragmentation.
It is rebuild not drop and create. We have multi master replication running.
Is there any problem to replication if I do that. Has anyone tried
PROTECTED]
cc:
Subject:Re: any problem rebuilding indexes used for
replication
renu (and Jared),
The reason I'm very interested in whether there's performance improvement
is
that there's a thread on the newsgroup about index rebuild recently. See
http
PROTECTED]
Sent by: [EMAIL PROTECTED]
11/05/2003 06:14 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:any problem rebuilding indexes used for
replication
]
Sent by: [EMAIL PROTECTED]
11/05/2003 06:14 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:any problem rebuilding indexes used for
replication
Hello,
I have to rebuild some
Hello,
Ihave torebuild some primary key indexesdue to excessive fragmentation. It is rebuild not drop and create.We have multi master replication running. Is there any problem to replicationif I do that. Has anyone tried it? TIA.
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
actually makes much
difference. (I don't know the answer but am very interested to know). Thanks.
Yong Huang
--- renu r [EMAIL PROTECTED] wrote:
Hello,
I have to rebuild some primary key indexes due to excessive fragmentation.
It is rebuild not drop and create. We have multi master replication
catrepr.sql and catrep.sql to recreate replication
catalog.
I was getting the same error even after recompiled all the invalid
objects(few packages were invalid). Then restared my instance and now it is
woking fine.
Thanks again
-tamizh
- Original Message -
Date: Saturday, October 25
Hi List,
We have 4 multi master database setup in our shop and like to isolate
(disconnect/remove) one of the database from replication.
What are the steps to be performed( the remaining 3 db should not be affected).
Thanks in advance
-tamizh
--
Please see the official ORACLE-L FAQ: http
Hi List,
We have 4 multi master database setup in our shop and like to isolate
(disconnect/remove) one of the database from replication.
What are the steps to be performed( the remaining 3 db should not be affected).
Thanks in advance
-tamizh
--
Please see the official ORACLE-L FAQ: http
I'm sorry - been very busy these last several days.
Yes, a somewhat flippant answer, but I built replication for our place
(asynchronous, master-master, multiple remote instances with full constraint
support) years ago, and its still running very reliably. Must be cheaper
than Oracle's product
Hi List,
Coudl someone please help me out to resolve this issue?
1 begin
2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04062: of has been changed
ORA-04062: timestamp of package
Have you recently made any changes to your database?
Upgrades, etc?
This is the message you will receive when the state
of a package is invalid. It either needs recompiled,
as something it is dependent on has changed, and/or
it is broken for the same reason.
One possible explanation for this
Thanks Jared.
Recently we did run catrepr.sql and catrep.sql to recreate replication catalog.
I was getting the same error even after recompiled all the invalid objects(few
packages were invalid). Then restared my instance and now it is woking fine.
Thanks again
-tamizh
- Original Message
There's another script for this as well, but I can't recall
it at the moment. The above script is generally used as
a final step in an upgrade.
Jared
Hi Jared,
Did you mean:
utlirp.sql - UTiLity script to Invalidate Recompile Pl/sql modules
Which does the extra invalidate first that
Thanks Pete, that was the one.
Jared
On Sat, 2003-10-25 at 15:09, Pete Finnigan wrote:
There's another script for this as well, but I can't recall
it at the moment. The above script is generally used as
a final step in an upgrade.
Jared
Hi Jared,
Did you mean:
utlirp.sql -
Hi all,
I am trying to setup a replication and it went smoothly up-to here, any ideas what I can do...
SQL EXECUTE Dbms_Repcat.Create_Master_Repobject('TEST55', 'TESTHOST5', 'TABLE', gname='MYREPGRP',copy_rows=false);BEGIN Dbms_Repcat.Create_Master_Repobject('TEST55', 'TESTHOST5', 'TABLE', gname
Hi all,
I have an environment where we are replication from Master to Slave a number of tables.
But there is one table which needs to replicate also both ways.
Currently I have setup snapshots/mviews master-slave, how I can implement this one table to be replicated also other way...
rgds
--_=_NextPart_001_01C39882.D1104260
Content-Type: text/plain; charset=iso-8859-1
Use Oracla's advanced replication (only available with Enterprise Edition).
Or use the patented Robson method!!
peter
-Original Message-
Sent: Wednesday, October 22, 2003 11:45 AM
To: Multiple
Peter,
your reply was empty, could pls. send it again, maybe
you have valuable information...
rgds
gb
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
--
Hi List,
I am getting ORA-23394: duplicate propagator, but when
I execute DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR, it
says
ORA-23357: the propagator does not exist.
How do i resolve this issue? Anyhelp would be really
greatful.
Kindly see below
=
SQL connect system/[EMAIL
From: Govindan KSent: 9/25/2003 1:15:22 PMTo: [EMAIL PROTECTED];[EMAIL PROTECTED]Subject: Re: Replication from DB2 to Oracle
Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication
across Databases of diff.vendors is still not avbl. though it seems you can do DMLs
. The
replication can be every couple of hours. Our main concern is performance on
the transactional system ( source system running db2) should not have
significant performance impact.
Thanks.
Thanks
Rishi Jain
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET
Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication
across Databases of diff.vendors is still not avbl. though it seems you can do DMLs
from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G.
Don't know about the reverse.
Or you may considering
replicate data between DB2 and Oracle ? Are there any good products out in
the market ? I would really appreciate if you could suggest something.
I am looking to replicate around couple of hundred thousand rows a day.
The
replication can be every couple of hours. Our main concern is performance
Sorry if my question sounds too simple.
what are the pros/cons of the above?
Where will deftran be stored? System tbs?. Should i increase my
system tbs size.
Thanks
Quriyat DBA
___
No banners. No pop-ups. No kidding.
Introducing My Way -
Replication is completely different story and independent from archive mode,
thus everything will remain the same (well, unless you're doing replication
with Streams, but that's a different story)
Deftran is a view which is based on def$_aqcall and def$aq_error tables,
these tables are in system
Dear Friends,
Can somebody send me / direct me to startup documents for ORacle
Replication.
TIA,
Rajuveera
**
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain
For replication docs, go to:
http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a87499/toc.htm
Fermin.
-Mensaje original-
De: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 10 de septiembre de 2003 13:09
Para: Multiple recipients
to do this. Since we're going to 9i fairly
soon I was thinking of setting up logical standbys, but I've read some
pretty bad things about logical standbys -- typical new buggy Oracle
product.
I've also started into looking at basic replication: maybe just simple
updateable snapshots refreshed every
Walt,
I presented a paper at IOUG Live 2003 and wrote an article on DBAZine on an
issue similar to this. Although the issue addressed was something much more
complex; the article does have scripts to set up a basic readonly snapshot
(or MV) replication. The article is at http://www.dbazine.com
I have attached some generic scripts for creating the snapshots and
refresh procedures. The only item missing is the database link.
Basic outline:
1. create database link
2. create snapshot logs on primary
3. create snapshots on copy
4. run a full refresh
5. run a fast refresh
6. setup jobs with
Weaver, Walt scribbled on the wall in glitter crayon:
Okay, we have a request for quite a few of our customers for read-only
copies of their databases they can do their ad-hoc queries on. These
read-only databases need to as closely matched to the production
database as possible, i.e.,
: A basic replication question
Weaver, Walt scribbled on the wall in glitter crayon:
Okay, we have a request for quite a few of our customers for
read-only
copies of their databases they can do their ad-hoc queries on. These
read-only databases need to as closely matched to the production
ad-hoc queries
as in, we'll write something that will bring your database to its knees
that kind of reporting, it's better to have a separate database
--- Thater, William [EMAIL PROTECTED] wrote:
Weaver, Walt scribbled on the wall in glitter crayon:
Okay, we have a request for quite a
into looking at basic replication: maybe just simple
updateable snapshots refreshed every now and then.
So, for the past couple of days I've gone through Metalink, Technet, and
the mail archives on Oracle-l trying to learn about simple, basic,
readonly replication.
The problem is, all of the manuals
Hi list
I am using Oracle 9.2.0.1.0 enterprise on windows.
I am going thru the examples provided in Replication
Management API Reference-Part No. A96568-01.
While creating MVIEW REPLICATION GROUP, getting the
following error (page # 5-7)
SQL CONNECT mviewadmin/[EMAIL PROTECTED]
Connected
Hi list
I am using Oracle 9.2.0.1.0 enterprise on windows.
I am going thru the examples provided in Replication
Management API Reference-Part No. A96568-01.
While creating MVIEW REPLICATION GROUP, getting the
following error (page # 5-7)
SQL CONNECT mviewadmin/[EMAIL PROTECTED]
Connected
.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 4:24 PM
mastered at ORC1.WORLD
Hi list
I am using Oracle 9.2.0.1.0 enterprise on windows.
I am going thru the examples provided in Replication
Dear Arup,
Thanks for your response. But i have done the same
which is mentioned in page # 3-6(Replication API
Reference Manual). Please see below. What else could
be wrong? TIA
CONNECT repadmin/[EMAIL PROTECTED]
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP (
gname = 'hr_repg');
END;
/
BEGIN
Sami,
Setting up replication is pretty straight forward as long as you follow all
the steps dilligently. Unfortunately if a step is missed, it's hard to
diagnose the problem until one is at the terminal looking at the actual
database. In this case there are several steps that my not have been
Hi there
In the past few weeks, there have been lots of discussion about HA, data
replication
and using Shareplex, dataguard, Streams, logical physical
standby. As most of you
have found out each has it own pros and cons. You also need two
sets of Database licences
and Shareplex licences
With the talk about replication lately, I thought I would see what might be
out there in book land and came across this. It is currently a vapor book.
http://www.dba-oracle.com/bp/bp_book4_replication.htm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
Hello Robert
We are working with advance replication in 8.1.6.3.4.
You need the following in the instances:
global_names = true
unique global name in each database
job_queue_processes = 10 ( at least)
archive enabled
I will send you offline the script that I use to create replication.
It does
One good book to have is Oracle Built-in Packages from O'Reilly. It does
more than merely show the syntax for the packages, but shows how the
packages are used. There is a chapter on Advanced Replication. I have
found this book to be one of the more useful books that I have bought.
--
Please
Robert -
I have studied this issue quite a bit and my opinion (based on reading,
not experience) is that the success in replication is in the organization,
not the technology. The question is whether your organization and
application are ready for replication. It sounds like you have some
We'll need to set up multi-master replication between two 8.1.7 databases within the
next few months. We're not experienced with replication beyond relatively simple
snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed
resources we can use to get up to speed
Title: Message
I was asked of a
problem in a friend's site about replication.
The
problem.
They implemented
replication using Materialized Views with an refresh update of ON DEMAND and
some immediate. It works for some days and suddenly some MV stop
replicating.
He has checked
metalink
it fails
on.
HTH.
Arup Nanda
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 21, 2003 8:19
AM
Subject: Replication
I was asked of a
problem in a friend's site about replication.
The
problem
Title: Message
Thks
Arup, I'll let him know those points.
Tks
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Arup NandaSent:
Friday, February 21, 2003 10:30 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: Replication
Yep - advanced replication is updateable snapshots and master-to-master replication,
whereas basic replication is read-only snapshots (known these days as materialized
views). And here's the reply from Dominic Delmolino regarding versions:
Hey Mogens!
I'll be seeing you
The person I know who can answer this is the guy who was Mr Replication
in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was
truly a pioneer with that stuff. I'll ask him and get back.
Mogens
DENNIS WILLIAMS wrote:
Chaim - I agree with your note, but isn't that basic
I believe that Advanced Replication was just a name change,
introduced in either Oracle8 or Oracle8i.
PB
--- Mogens_Nørgaard [EMAIL PROTECTED] wrote:
The person I know who can answer this is the guy who was Mr
Replication
in Cary's SPG-group from the beginning, namely Dominic Delmolino. He
Paul - That is not my understanding. If you look in the Oracle guide that
shows the differences between Standard Edition and Enterprise Edition,
Standard has something named Basic Replication, and Enterprise has
Advanced Replication. Advanced means multimaster replication. Basic means
snapshots
My understanding is that Basic replication is readonly snapshot.
Anything above that, including updatable snapshot is advanced replication.
Richard
-Original Message-
Sent: Wednesday, January 29, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L
Paul - That is not my understanding
Any of you Oracle history buffs remember what version of Oracle that
advanced replication was first available in?
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find
from metalink note: 28018.1
5.14 Symmetric Replication
To: Multiple recipients of list ORACLE-L
from metalink note: 28018.1
5.14 Symmetric Replication
---
The Oracle symmetric
replication facility is new with
release 7.1.6. The symmetric
replication facility allows
multiple copies of data to be
maintained
Chaim - I agree with your note, but isn't that basic replication? Robert
asked about advanced (multimaster) replication.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To: Multiple
Title: RE: Replication question
We don't update data on slaves, we update data from master then slave pull data from the master every 5 minutes.
David
-Original Message-
From: BigP [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 7:59 PM
To: Multiple recipients
We have four machines setup as slave databases which get updated data from
one Master database every 5 minutes. The question is how do I know all
slave machines get updated data completely from the master database, another
word is how do I know there is no missing data when slave machines
it depends on how you are updating slave databases .
-bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 3:39 PM
We have four machines setup as slave databases which get updated data from
one Master database every 5
Hello!
That's one of the nuances of MV replication. If you alter the master
table,
you have to drop and recreate the MV on the snapshot site. This is as
per Oracle's internal documentation.
:-(
However, there is a trick. If you have created the MV using a prebuilt
table, then you can have
PROTECTED]
Sent: Monday, January 20, 2003 9:44 AM
replication environment
Hello!
That's one of the nuances of MV replication. If you alter the master
table,
you have to drop and recreate the MV on the snapshot site. This is as
per Oracle's internal documentation.
:-(
However
Larry,
As far as I am concerned my present problems are linked to an unpleasant tendency
of MTS to freeze, and, while looking at $ORACLE_HOME/rdbms/mesg/oraus.msg for a
possibly suitable event to set to get some information, I bumped into 10975 which may
possibly be useful in your case.
Hi David
It sounds like Advanced Replication to me. The question is: Will the data
you move from instance A to instance B also be changed on instance B ? Is it
necessary to propagate changes back to instance A ? - Master-Master
Replication.
Will the data on instance B remain unchanged and only
Dennis,
That's one of the nuances of MV replication. If you alter the master table,
you have to drop and recreate the MV on the snapshot site. This is as per
Oracle's internal documentation.
However, there is a trick. If you have created the MV using a prebuilt
table, then you can have
choice (if it's available) will not be available in any
Oracle releases before 9.2.
The second method if it's available will be available for a big packaged
Oracle option like replication.
I asked a friend who handles replication and here is the thread:
-Original Message-
Sent
was asking about reverse key indexes and if anyone had seen
issues. The Oracle replication query to resolve what to process was running
for a few hours, just the query -- I would pull it out and run it, very bad.
But the execution plan was good, what we would want. The PK was a reverse
key index
Hello
How can i replicate DDL on table (modify column for example) in
materialized view replication environment ?
DBMS_REPCAT.ALTER_MASTER_REPOBJECT alter the object, put changes are not
propagated to MV site ...
I try DBMS_REFRESH.REFRESH and DBMS_REPCAT.REFRESH_MVIEW_REPGROUP at MV
site
Hi Larry,
In the distributed manual it
makes a comment about DML serializing when doing remote operations.
I am not sure about replication but in the past (on 8.1.5 and 8.1.6
versions) this has been my experience with CTAS over a dblink or DML over
dblink in that it serializes.
In order
the parallelism parameter of
the DBMS_SNAPSHOT.REFRESH. Well this didn't do it. Then he comes back and
says it is possible to replicate a single table using parallelism if you use
advanced replication (or maybe we read that somewhere). Guess I'll create a
second 8.1.7 DB on my home machine and give
I am not sure about replication but in the past (on 8.1.5 and 8.1.6
versions) this has been my experience with CTAS over a dblink or DML over
dblink in that it serializes.
In order to achieve parallelism, the only workaround we had was (though
not pretty :-) ) to use the ROWID hint
parallelism of multiple tables at one time.
And this way they get paged with a specific should something fail.
Regarding the other comments, the replication logic seems to handle the
dependency you are talking about. There really isn't any order per se, so
the same issues you raise would apply to serial
Message-
Sent: Tuesday, January 14, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
I am not sure about replication but in the past (on 8.1.5 and 8.1.6
versions) this has been my experience with CTAS over a dblink or DML over
dblink in that it serializes.
In order to achieve parallelism
that never forgets anything, never forgetting any nuance or issue ;-) )
spent a little time this afternoon ripping 230 million rows from a large
dimension across the db's. That was the workaround because the standard
replication as is just couldn't handle the recent increase in the volume
of changes
the standard
replication as is just couldn't handle the recent increase in the volume
of changes. So normal replication couldn't keep up. And probably right now
he is switching the objects, renaming and handling the grants -- our only
occasional window before nightly stuff kicks in. So do a full copy from
a TAR to get an
explanation -- the analyst said to simply use the parallelism parameter of
the DBMS_SNAPSHOT.REFRESH. Well this didn't do it. Then he comes back and
says it is possible to replicate a single table using parallelism if you use
advanced replication (or maybe we read that somewhere
Our current master is 8.1.6.3 as is our Snapshot database. However, at
some time in the future our master database will be upgraded to 8.1.7.4.
Our options are to stay with 8.1.6.3, upgrade to 8.1.7.4, or upgrade to
9.1.2. We can do this either before or after the master's upgrade.
So our
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun Solaris
2.7.
In the replication group, we would like to add a new column to a replicated
table.
Not only that, we would like to add this new column to the primary key of this
replicated table.
What are the steps
the master
definition site.
This package is intended to replicate changes made to objects that
belong to a replication group, so it should be suitable for use here,
as well as being a whole lot simpler than the approach you'd otherwise
have to take.
HTH.
--- [EMAIL PROTECTED] wrote:
To all,
I
The only reason is that we have to change the primary key constraint. That's
mean, we got to drop and recreate the primary key constraint. And if the
replicated object is still in the replication group, it probably won't allow me
to drop the primary key though. (or maybe I got it all wrong
Building replication is usually somewhat lengthy process.
I spent sometime with an Oracle expert and built a skeleton script
to build my replication via sqlplus.
However, I use the replication manager to track the progress of
the build process and to check the results.
Yechiel Adar
Mehish
1 - 100 of 370 matches
Mail list logo
