I've had some problems with 8.1.5 on NT where snapshots did not deregister properly when dropped -- preventing purging. If you've ever destroyed snapshots on one of your machines you might check DBA_REGISTERED_SNAPSHOTS on the master to see if there are 'extras' which you can then deregister manually. "Fowler, Kenneth R" wrote: > Version of oracle?? I know from personal that 8.1.6 has problems with > snapshot logs not being purged. > > -----Original Message----- > Sent: Wednesday, March 07, 2001 4:17 PM > To: Multiple recipients of list ORACLE-L > refreshed from master? > > Hello Forumists, > > How to know which are the snapshots supposingly to get > refreshed from the master? In my situation, I have > around 40 databases refreshing from a single master > and seems to be all the 40 databases' snapshots are > getting refreshed. So, why my snapshot still grows > without purging automatically is the question. If I > manually purge the snapshots using > dbms_snapshot.purge() procedure then, I have to make a > COMPLETE refresh for all these snapshots which will > involve more efforts. So, I would like to know if > there is a way to find which are the snapshots > supposed to refresh from master. Perhaps there is a > way to find this out at the master using some > dictionary tables etc..which I am not aware of. If > anybody has an idea please let me know. > > Thank you very much, > Muru > > __________________________________________________ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Muru > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Fowler, Kenneth R > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
