RE: Oracle Replication: unregistering a snapshot

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sarah Satterthwaite Sent: Tuesday, May 10, 2005 3:58 PM
To: 'oracle-l_at_freelists.org'
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_at_cswv.com

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue May 10 2005 - 16:08:46 CDT