Re: Snapshot too old
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: piontekdd@xxxxxxxxx
- Date: Tue, 16 Feb 2010 08:17:57 -0600
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:
