OraFAQ Forum: Performance Tuning » Error in Materialized view refresh

Home » RDBMS Server » Performance Tuning » Error in Materialized view refresh (Oracle Database)

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

Error in Materialized view refresh [message #359259]

Fri, 14 November 2008 07:36

mac4rfree
Messages: 2
Registered: November 2008
Location: Mumbai

Junior Member

Hi Guys,

I am new to this forum. I have a problem.
We have scripts which will refresh the materialised views.
We have 11 MV(materialised views).
Out of them 10 are successfully refreshed whereas one of them is throwing an exception when refreshed.

The exception is
Unhandled Exception Raised when refreshing Materialized View-DCX_PIECE_COST_GROUP_BY_PART_V : -12008:ORA-12008: error in materialized view refresh path
ORA-01562: failed to extend rollback segment numb

Please help me out with this..

Thanks for your help in advance..
Magesh

Report message to a moderator

Re: Error in Materialized view refresh [message #359261 is a reply to message #359259]

Fri, 14 November 2008 07:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is what Oracle says:

Oracle

ORA-01562: failed to extend rollback segment number string

Cause: Failure occurred when trying to extend rollback segment

Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintenance. Use the alter rollback segment offline command to take the rollback segment offline.

Report message to a moderator

Re: Error in Materialized view refresh [message #359264 is a reply to message #359261]

Fri, 14 November 2008 07:58

mac4rfree
Messages: 2
Registered: November 2008
Location: Mumbai

Junior Member

yes little foot,,
i too saw it earlier..
but if u see my error message,,it is saying as
ORA-01562: failed to extend rollback segment numb
whereas in the message it has to be some number as per oracle..
Still can u advise me as what to do in this scenario?

Thanks for helping..
Magesh

Report message to a moderator

Re: Error in Materialized view refresh [message #359417 is a reply to message #359264]

Sat, 15 November 2008 14:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As the documentation says that

Quote:

This is normally followed by another error message that caused the failure

was there any subsequent error message (such as "maximum number of extents reached for this rollback segment" or ...)?

Report message to a moderator

Previous Topic:	package performance
Next Topic:	Wait events

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 03:20:24 CST 2025