Hi!
Just for the record, one other solution would probably have been to set
REMOTE_DEPENDENCIES_MODE = SIGNATURE.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, October 25, 2003 10:24 PM
Thanks Jared.
Recently we did run
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...
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 -
--_=_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
--
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
if any that are
being done in DB2. The same need to be propogated to Oracle too and the
subsequent data inserted correctly.
HTH
GovindanK
-Original Message-
From: [EMAIL PROTECTED]Sent: 9/25/2003 12:05:43 PMTo: [EMAIL PROTECTED]Subject: Re: Replication from DB2 to OracleHi, Do any of you
Oracle heterogenous services + ODBC.
Included in EE, maybe in SE as well.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 10:09 PM
Hi,
Do any of you have any recommendation about any tools / software which
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
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
Before you create the Materialized View Group, you must create the REPGROUP
at the Master site, which in you case is ORC1.world.
In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and
DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure
DBMS_REPCAT.CREATE_MVIEW_REPGROUP.
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
Title: Message
Is the MV set up for FAST REFRESH or
COMPLETE?
If FAST REFRESH, check to see if the tablespace of
MV Log table, named MLOG$_tablename where tablename is the first
20 characters of the table on which the log is based, has enough space for the
mlog$ to grow.
If complete
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 at the
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.
from metalink note: 28018.1
5.14 Symmetric Replication
---
Thanks!
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 on Amazon.com!
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 2:12 PM
To:
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
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
Dennis,
I am glad that it worked for you. Of course, it's useful if the table size
is big. In case of a small table, you would just drop and recreate the
snapshot.
Thanks for pointing out the typo.
Regards,
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
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 a
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
-
Replication Manager is a part of DBA Studio on OEM with 8i; On OEM with 9i,
the DBA Studio is gone; so the replication manager is on OEM Console.
I use it, for a quick and dirty look at things. I don't use it to create
replication objects etc. However thjat's simply becuase I never used it
earlier
You can run asynchronos rep from server A to C, then
run a snapshot to B off of C (have C be the master to
B)
Make sure you have conflict resolution set-up!
--- Eric Richmond [EMAIL PROTECTED] wrote:
I read that any given object can be in only one
replication group. We already
have SNAPSHOT
of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
root@fatcity.Subject: Re: Replication
PROTECTED]
cc:
Subject:Re: Replication
This is definitely possible with RMAN. The only hitch is that in case you
use RMAN to write to disk, the same directory structure must exist on the
target server. The workaround would be to create soft links. Also, in
case,
you
Robin
Your management sounds like some people I dealt with that assumed they
would just flip the replication switch. How much of the 30-gig. do they
plan to replicate? What replication interval? What tools do they plan to
use? What is the replication direction - master-slave, peer-peer? How
I have recently heard some people say it had taken them several months to master, and
*now* it would take them about 15 days to implement.
- Original Message -
From: Robin Li [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 14 Oct 2002 05:58:24
Hi
etc. Not Oracle's solution, though, but it is master/master. Come to
PLOUG next week and hear about it...
peter
-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: 14 October 2002 15:59
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication
I
: Monday, October 14, 2002 8:58 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication
Robin
Your management sounds like some people I dealt with that assumed they
would just flip the replication switch. How much of the 30-gig. do they
plan to replicate? What
: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Monday, October 14, 2002 8:58 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication
Robin
Your management sounds like some people I dealt with that assumed
they
would just flip the replication
2002 15:59
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication
I have recently heard some people say it had taken them
several months to master, and *now* it would take them about
15 days to implement.
- Original Message -
From: Robin Li [EMAIL PROTECTED
Is this simply replicating data to another system read only?
Replicated for what purpose? High Availability? Querying and reporting?
Jared
Robin Li [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/14/2002 06:58 AM
Please respond to ORACLE-L
To: Multiple recipients of
Thanks to all who replied.
The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By
]
cc:
Subject:Re: Replication
Thanks to all who replied.
The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which
:
[EMAIL PROTECTED] Subject: Re: Replication
om
Paul - I don't know multimaster replication, so bear with me. I am thumbing
through my copy of Oracle Distributed Systems by Charles Dye. Does your
question relate to how propagation is controlled? I think propagation is
controlled by scheduled jobs. Take a look at the procedure
Paul,
The procedures are executed by a special internal trigger. These
triggers are also NOT dropped by catrepr.sql (yes, I found out the
hard way!). It is documented in metalink.
HtH,
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Wednesday,
Title: RE: Replication question
Great book, I have it too!
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question
Paul - I don't know multimaster
Thanks, John. Do you know what mechanism causes the internal triggers
to fire? Are the internal triggers created by catrep.sql, or by
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table?
Does the RDBMS have to determine whether
--- John Weatherman [EMAIL PROTECTED] wrote:
Paul,
The
The jobs are used to propogate the captured transactions.
The transactions are captured by the packages called by the
internal triggers.
PAX,
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Thursday, September 05, 2002 10:28 AM
To: Multiple
I once noticed this code which is executed (for each column?) when you
create a table. Would it be related to replication?
BEGIN
2. /* NOP UNLESS A TABLE OBJECT */
3. IF dictionary_obj_type = 'TABLE' THEN
4.
Paul,
Dispite being internal the triggers are triggers just like any
others. INSERT, UPDATE, DELETE all fire the package (all the
transactions you want to move). I have NEVER been clear on the
relationship between these triggers and user defined ones, sence
you suposedly can't control the
Use the KISS principle.
Define asynchronous replications on their machines and when they come back
and connect to the network the updates will be applied.
TEST TEST TEST
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday,
Oracle has basic replication and advanced
replication. The basic allows read-only copies of
data whilst advanced can give multiple updaters at
different locations and can get as complicated as you
like.
IMHO, the key to a good replication environment is in
the planning. Determining up front
Oracle Lite is designed to do this -- the content-deployment part for
standalone applications is a little buggy, but the data deployment and
web-app deployment seems to work. We're instituting a couple of
applications with this now, and data sync seems to be working fine.
Application sync has
Don,
What are you using for deploy the applications ??
I am interested in this topic too.
Ramon
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 10:33 AM
Oracle Lite is designed to do this -- the content-deployment part
Hi,
Oracle Lite would not be good for us as when I said
users are working with a deployable version, I mean a
bunch of users go away with their server/database and
come back 2-3 months after, then they synchronized the
master database.
--- Don Jerman [EMAIL PROTECTED] a écrit :
Oracle Lite
The application will be developped in ASP, the
deployed version would juste be a lighter version of
the main application.
--- Ramon E. Estevez [EMAIL PROTECTED]
a écrit : Don,
What are you using for deploy the applications ??
I am interested in this topic too.
Ramon
-
Stephane - Have you considered transportable tablespaces?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, August 02, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
Hi,
Oracle Lite would not be good for us as when I said
users are
tks
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 02, 2002 11:39 AM
The application will be developped in ASP, the
deployed version would juste be a lighter version of
the main application.
--- Ramon E. Estevez [EMAIL
Yes that's how it works, although the volume for 2-3 months might be
excessive, if the deltas get large. Light uses Advanced Replication to
manage the deltas so the resolution process might take a while.
paquette stephane wrote:
Hi,
Oracle Lite would not be good for us as when I said
users
Light works with a 9ias application (part of the Light package) to establish
the mobile database and application on the mobile client. Once the
application and database are downloaded, the database uses Advanced
Replication to sync with the master when the clients are brought back to the
At a previous job, I've tested the first version of
Oracle Lite in 1996 if I remember correctly. The
concept of user did not exist, I do not know if it has
changed. In my case, several users will connect to the
same database. So I guess I'll need the Workgroup
version.
--- Don Jerman [EMAIL
So how do I get into the archives? I've got a question I know I've seen
answered.
Thanks,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services
John - I've noticed that Google queries pull up info from the archives.
Obviously you'll get other stuff, but if you can make your query pretty
specific it may get you what you need.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 30, 2002
Vladimir,
When a table is truncated, its
snapshot log is also truncated.
If the PURGE SNAPSHOT LOG option is specified,
the snapshot log is purged along with the master table. If you specify the PRESERVE SNAPSHOT LOG option or no option,
the information in the master table's snapshot log
Take a look in the docs at the syntax:
truncate table tablename preserve/purge snapshot log;
The SNAPSHOT LOG clause lets you specify whether a snapshot log
defined on the table is to be preserved or purged when the table is
truncated. This clause allows snapshot master tables to be
reorganized
-Original Message-
From: Lowes, Harry (NESL-IT) [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2002 13:37
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question
Peter,
Great idea, but would you care to share the impact of these
triggers on
performance? I think it's a good
Sakthi , Raj wrote:
Hi Listers,
alright I've exhausted almost all my resources and I
am turning to my last resource.
We have 3 databases.
Database A - OLTP
Database B - OLTP
Database c - DSS
ORACLE 8.1.6.3 ON HP-UX 11.0
Database A has a table which is being
Interesting comments on replication - but something hit me between the eyes.
Primary Keys should NEVER, EVER be permitted to be updated, whether you are
using replication or not. Its a basic tenent of relational design. We have
been using triggers to prevent this for years.
peter
edinburgh
Peter,
Great idea, but would you care to share the impact of these triggers on
performance? I think it's a good principle to follow, but have always found
triggers a little unwieldy for most operations myself. I would have thought
this to be the case here, but I'd like to hear your experiences
ps. you work with Elmer Cecelio?
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Andrew Sit
[EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question
Dennis et al
, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question
Just a note, Johanna. We put all of our Oracle Replication metadata
into separate tablespaces, and had absolutely no problems.
Brian
--
| Brian
[EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Replication question
Yechel - Wow, what a blow to be struck with the
dreaded RTFM first thing in
the morning. Thanks Yechiel, I needed that.
Actually, I
: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw
[EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question
Just a note, Johanna. We put all of our Oracle Replication metadata
into separate tablespaces
On Behalf Of Brian McGraw
[EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question
Just a note, Johanna. We put all of our Oracle Replication metadata
into separate tablespaces, and had absolutely
On
Behalf Of Brian McGraw
[EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Replication question
Just a note, Johanna. We put all of our Oracle
Replication metadata
into separate tablespaces, and had absolutely
Hi all
I will work on replication soon. any advice for reference I can get.
Thanks in advance.
Mitchell
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 10:58 AM
We are just starting to look at replication so each
Mitchell,
There are a LOT of good papers in Metalink. I've been getting my own
education over the last few months. Replication is a really great swiss
army knife though, you need to do a little looking for what you specifically
need to do, then test, test, test. Oh, and did I mention test? :)
Mitchell - My knowledge is mostly from reading at this point, but here are
some thoughts that a colleague provided from his experience:
- backup and recovery is much more complicated in a replicated environment
so it needs to be planned
- replicated databases inevitably get out of sync so some
by: [EMAIL PROTECTED]
06/14/2002 09:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Replication question
Mitchell,
There are a LOT of good papers in Metalink. I've been getting my own
education over
:
Subject:RE: Replication question
Mitchell,
There are a LOT of good papers in Metalink. I've been getting my own
education over the last few months. Replication is a really great swiss
army knife though, you need to do a little looking for what you
specifically
need to do, then test
John Weatherman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
06/14/2002 09:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Replication question
Mitchell,
There are a LOT
Title: RE: Replication question
Another potential HA use of AR is that you can use different platforms in an HA configuration. You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored.
Yet another is during
]
cc:
Subject:RE: Replication question
Mitchell,
There are a LOT of good papers in Metalink. I've been getting my own
education over the last few months. Replication is a really great
swiss
army knife though, you need to do a little looking for what you
specifically
/2002 09:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Replication question
Mitchell,
There are a LOT of good papers in Metalink. I've been getting my
own
education over
Hi,
I changed the Subject to SHAREPLEX, lets close out the contention thread.
Could be why there are no responses. A couple people on the list definitely use it
and I know I certaintly will have a lot to say about it but have to do it later as I
am working on Prod issues right now.
then is it possible to make secondary
server(snapshot server) once and vice versa.
Thanks
-Seema
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 13:09:19
be
on server2.please suggest how to do this if possible.
thx
-Seema
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 14:43:25 -0800
Seema -
I have only done
Seema - You could buy a separate replication package to do this, but you
probably couldn't justify the cost.
You could simply write some scripts to do this. But if you use
Oracle's Basic Replication, then you get some resume material as a bonus.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL
Now that depends on how big the tables are? A few options off the top of my head:
1) Drop tables, export, import.
2) Replication.
3) Truncate, insert from select as.
4) Spool data, sql*load it.
so many ways to skin a cat...
I would probably play w/ replication.
[EMAIL PROTECTED] 04/19/02
-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 10:08:50 -0800
Now that depends on how big the tables are? A few options off the top of
my head:
1) Drop tables, export, import.
2) Replication.
3) Truncate, insert
-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 10:08:50 -0800
Now that depends on how big the tables are? A few options off the top of
my head:
1) Drop tables, export, import.
2) Replication.
3) Truncate, insert
Is there any additional software required if i go to advanced replication?
-seema
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 10:03:57 -0800
Seema - You
.
Thx
-Dinesh
From: Gene Sais [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 10:08:50 -0800
Now that depends on how big the tables are? A few options off the top of
my head:
1
Is it Multimaster
replication.
Thx
-Dinesh
From: Gene Sais [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 10:08:50 -0800
Now that depends on how big the tables are? A few options off the top
]
Subject: RE: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 10:03:57 -0800
Seema - You could buy a separate replication package to do this, but you
probably couldn't justify the cost.
You could simply write some scripts to do this. But if you use
Oracle's Basic Replication, then you get some
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 13:09:19 -0800
Seema - Advanced replication is a feature of Oracle Enterprise Edition, so
if you have that, you should be set. Based on your description, updatable
snapshots may meet your needs
(snapshot server) once and vice versa.
Thanks
-Seema
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: REPLICATION/FAIL OVER
Date: Fri, 19 Apr 2002 13:09:19 -0800
Seema - Advanced replication is a feature
1 - 100 of 128 matches
Mail list logo