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> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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

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