Re: Snapshot too old

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 16 Feb 2010 08:17:57 -0600
Message-ID: <ad3aa4c91002160617j5da455dal6b234956d46f9e6e_at_mail.gmail.com>

I think the 'ora-02063 line preceding message from' line means its from the remote db.

On Tue, Feb 16, 2010 at 8:15 AM, Bradd Piontek <piontekdd_at_gmail.com> wrote:

> Bill,
> That is almost certainly on the master site. One big indicator is the
> blank Undo segment name. Another way to verify is to check the alert log.
> ORA-1555 errors are typically logged there as well.
>
>
> Bradd Piontek
> Pythian - Love Your Data
>
>
>
> On Tue, Feb 16, 2010 at 8:04 AM, Bill Zakrzewski <bill_at_intactus.com>wrote:
>
>> All -
>>
>> I am refreshing a materialized view and occasionally receive the below
>> error. Should I be looking at the local database rollback segment or the
>> remote databases rollback segment? As I don't believe anything is running
>> locally it must be on the remote database, but wanted to verify before I
>> start trying to tune/fix the issue in the wrong database.
>>
>>
>> ORA-12012: error on auto execute of job 42
>>
>> ORA-12008: error in materialized view refresh path
>>
>> ORA-01555: snapshot too old: rollback segment number with name "" too
>> small
>>
>> ORA-02063: preceding line from FEMA_ODS
>>
>> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
>>
>> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
>>
>> ORA-06512: at "SYS.DBMS_IREFRESH", line 685
>>
>> ORA-06512: at "SYS.DBMS_REFRESH", line 195
>>
>> ORA-06512: at line 1
>>
>>
>> Thanks
>> Bill
>>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Tue Feb 16 2010 - 08:17:57 CST