s in 3 tables would
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]>
> >Su
[EMAIL PROTECTED]
> >
> >
> >-Original Message-
> >Sent: Friday, April 19, 2002 3:49 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Is there any additional software required if i go to advanced
>replication?
> >-seema
> >
> >
&
condary
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
OTECTED]
>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 of Oracle Enterprise Edition, so
>if you have that, you should be set. Based on your d
RACLE-L <[EMAIL PROTECTED]>
>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
ould be good 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 -080
.
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 th
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,
CTED]>
>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:
>
>
CTED]>
>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:
>
>
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
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 P
12 matches
Mail list logo