Home » RDBMS Server » Performance Tuning » Error in Materialized view refresh (Oracle Database)
Error in Materialized view refresh [message #359259] Fri, 14 November 2008 07:36 Go to next message
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
Re: Error in Materialized view refresh [message #359261 is a reply to message #359259] Fri, 14 November 2008 07:50 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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.
Re: Error in Materialized view refresh [message #359264 is a reply to message #359261] Fri, 14 November 2008 07:58 Go to previous messageGo to next message
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
Re: Error in Materialized view refresh [message #359417 is a reply to message #359264] Sat, 15 November 2008 14:04 Go to previous message
Littlefoot
Messages: 20897
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 ...)?
Previous Topic: package performance
Next Topic: Wait events
Goto Forum:
  


Current Time: Wed Dec 07 10:59:14 CST 2016

Total time taken to generate the page: 0.16680 seconds