Home » RDBMS Server » Server Administration » Rollback segment error.
Rollback segment error. [message #187449] Mon, 14 August 2006 01:24 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Can you please explain what is the below error, how can i rectify this?

ORA-12012: error on auto execute of job 918
ORA-12008: error in materialized view refresh path
ORA-01555: snapshot too old: rollback segment number 19 with name "R18" too small
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 814
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 872
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 852
Re: Rollback segment error. [message #187465 is a reply to message #187449] Mon, 14 August 2006 02:25 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Have U removed Roll back Tablespace.
Re: Rollback segment error. [message #187497 is a reply to message #187449] Mon, 14 August 2006 04:22 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
No.
Re: Rollback segment error. [message #187508 is a reply to message #187497] Mon, 14 August 2006 04:48 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:

ORA-01555: snapshot too old:

search the forum/google for this error.
Already answered a zillion times.
Previous Topic: please help:ora-01503 create CONTROLFILE failed and ora-32700 error occured in DIAG services
Next Topic: listener up and down
Goto Forum:
  


Current Time: Sat Dec 03 13:59:08 CST 2016

Total time taken to generate the page: 0.08888 seconds