Re: ORACLE 8I AND SNAPSHOT PROBLEM

We are using read only snapshot and updatable snapshot on oracle81600/solaris2.7. Once for a while, there is a networking problem, but snapshots are never got truncated, still have data. Probably you need to contact support.

mike

• Original Message ----- From: Ashish Shah <ar_shah_at_yahoo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, September 22, 2000 10:51 AM Subject: ORACLE 8I AND SNAPSHOT PROBLEM

> Hi All,
>
> I didn't get any responce last time.. Can anyone
> help here !!!
>
> We are having strang problem after we upgraded
> our database to 8.1.6 from 7.3.4.
>
> Whenever there is a network problem snapshot gets
> truncated and then it only refreshes rows from
> snapshot log. It doesn't do full refresh.
>
> Before upgrade you only get failures and then once the
> network is up it will do a fast refresh and that's the
> way it
> should be.
>
> Does anyone else has the same problem ? I also
> applied 8.1.6.2 patch but no luck...
>
> TIA.
>
>
>
> =====
> Ashish
> Toronto, Canada
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ashish Shah
> INET: ar_shah_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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).
Received on Fri Sep 22 2000 - 11:28:01 CDT