Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Replication: unregistering a snapshot

RE: Oracle Replication: unregistering a snapshot

From: Sarah Satterthwaite <ssatterthwaite_at_cswcasa.com>
Date: Tue, 10 May 2005 17:38:16 -0400
Message-ID: <4FF77D01E13B214590F4FA3E2C3021D00143690E@pecos.csw.alewife.net>


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
Received on Tue May 10 2005 - 17:42:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US