Re: Snapshot too old

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@xxxxxxxxx> 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@xxxxxxxxxxxx>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.'

Other related posts: