RE: Oracle Replication: unregistering a snapshot
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <ssatterthwaite@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 May 2005 16:03:49 -0400
Have you checked Metalink? There is a procedure there to eliminate
snapshots when they've gotten really screwed up.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sarah Satterthwaite
Sent: Tuesday, May 10, 2005 3:58 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Oracle Replication: unregistering a snapshot
I have been testing Oracle Replication, single master with one updatable
snapshot site on Windows 2000, Oracle 8.1.7.4.
I have a snapshot registered at the master site that I cannot get rid
of.
All the objects at the snapshot site have been removed. My guess is
that I
failed to run dbms_repcat.drop_snapshot_repobject when I was cleaning up
the
snapshot site. Any suggestions on how to get rid of it now?
As I have scripted the creation of the replicated objects, I have also
tried
to write a corresponding drop script. They seem to work, but I would be
happier with some documentation to confirm that I have come up with the
proper way to do it. Does anyone have pointers to such documentation?
Thanks,
Sarah
_______________________
Sarah Satterthwaite
Database Administrator
Fiserv CSW, Inc
125 Cambridge Park Drive
Cambridge, MA 02140
Email: sarah@xxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
