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
12 matches
Mail list logo