OraFAQ Forum: Server Administration » Rollback segment error.

Home » RDBMS Server » Server Administration » Rollback segment error.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rollback segment error. [message #187449]

Mon, 14 August 2006 01:24

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

Report message to a moderator

Re: Rollback segment error. [message #187465 is a reply to message #187449]

Mon, 14 August 2006 02:25

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Have U removed Roll back Tablespace.

Report message to a moderator

Re: Rollback segment error. [message #187497 is a reply to message #187449]

Mon, 14 August 2006 04:22

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

No.

Report message to a moderator

Re: Rollback segment error. [message #187508 is a reply to message #187497]

Mon, 14 August 2006 04:48

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:30:57 CDT 2024