Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: snapshor replication
Still unclear to me :))
You need to study replication before attempting to do this.
I don't understand why there should already be a table at the snapshot site.
Snapshot means an exact copy of the master table in the snapshot site.
What you might be doing is "multi-master replication". Please read up on it a little and ask any question that you have on it.
Anurag
"May" <sunxushi_at_yahoo.com> wrote in message
news:8c0f1a9e.0109032345.70563eb2_at_posting.google.com...
> the 2nd problem is :
> if the table already exist both on master site and snapshot site, when
> you create snapshot at snapshot site, it will error:
> ORA-00955: name is already used by an existing object
> so you only to drop the table at snapshot site first, then create
> snapshot on it. but this is unaccept cause we are a 24X7 website.
Received on Tue Sep 04 2001 - 16:08:28 CDT