Home » SQL & PL/SQL » SQL & PL/SQL » getting error when executing procedure(ORA-01562:)
getting error when executing procedure(ORA-01562:) [message #294315] Thu, 17 January 2008 03:51 Go to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

i am getting a error when trying to run a pl/sql block.
SQL> /
DECLARE
*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 3
ORA-01628: max # extents (121) reached for rollback segment RB1
ORA-06512: at line 70


regards
jitender.
Re: getting error when executing procedure(ORA-01562:) [message #294320 is a reply to message #294315] Thu, 17 January 2008 03:58 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member



Quote:
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 maintainence. Use the alter rollback segment offline command to take the rollback segment offline.


Consult with your DBA

Thumbs Up
Rajuvan

[Updated on: Thu, 17 January 2008 03:59]

Report message to a moderator

Re: getting error when executing procedure(ORA-01562:) [message #294322 is a reply to message #294320] Thu, 17 January 2008 04:07 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

i am not taking the rollback segment offline ,i am simply running a pl/sql procedure & during that i am getting that errors.
when i tried to run that pl/sql block again and again ,i finally got success to run that pl/sql code.
but i want to know what is the cause of that error & the solution of that.

regard
jitender.
Re: getting error when executing procedure(ORA-01562:) [message #294326 is a reply to message #294322] Thu, 17 January 2008 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i am not taking the rollback segment offline

This is in "action" part and not in "cause" one.

The cause is:
Quote:
Failure occurred when trying to extend rollback segment


It depends on your workload.
This error can't happen in the current Oracle versions. What is yours?

Regards
Michel
Re: getting error when executing procedure(ORA-01562:) [message #294337 is a reply to message #294326] Thu, 17 January 2008 04:47 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

the oracle on which i am working is

Oracle8i Release 8.1.5.0.0 - Production
PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production


regards
jitender.
Re: getting error when executing procedure(ORA-01562:) [message #294349 is a reply to message #294337] Thu, 17 January 2008 05:14 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a locally managed tablespace for your rollback segments.

Regards
Michel
Previous Topic: error in executing procedure
Next Topic: Monthly Totals
Goto Forum:
  


Current Time: Wed Dec 07 03:03:08 CST 2016

Total time taken to generate the page: 0.10664 seconds