RE: Oracle Replication: unregistering a snapshot

Thanks. dbms_snapshot.unregister_snapshot worked. I thought I had tried that, but must have not done it correctly if I did. -----Original Message-----
From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Tuesday, May 10, 2005 4:46 PM
To: ssatterthwaite_at_cswcasa.com
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle Replication: unregistering a snapshot

So, have you looked at the dbms_snapshot package?

Login to the database and do a describe on dbms_snapshot.

Or take a look at the manual pages for dbms_snapshot.

You may want to try dbms_snapshot.unregister_snapshot.

On 5/10/05, Sarah Satterthwaite < ssatterthwaite_at_cswcasa.com
<mailto:ssatterthwaite_at_cswcasa.com> > wrote:

I have been testing Oracle Replication, single master with one updatable snapshot site on Windows 2000, Oracle 8.1.7.4 <http://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 <mailto:sarah_at_cswv.com>

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


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






-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist





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