Re: Snapshot too old
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: bill@xxxxxxxxxxxx
- Date: Tue, 16 Feb 2010 08:15:37 -0600
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
>
Other related posts:
