Re: REPLICATION/FAIL OVER

2002-04-20 Thread Nikunj Gupta
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

RE: REPLICATION/FAIL OVER

2002-04-20 Thread Seema Singh
[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 > > > > &

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
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

RE: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
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

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
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

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Gene Sais
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

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
. 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

RE: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
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,

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
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: > >

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Seema Singh
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: > >

Re: REPLICATION/FAIL OVER

2002-04-19 Thread Gene Sais
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

RE: REPLICATION/FAIL OVER

2002-04-19 Thread DENNIS WILLIAMS
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