Printable View
In reference to Jmodics reply to the following thread
http://www.dbasupport.com/forums/sho...?threadid=7525
Do RBS are used while creating Stored Procedurs, as they are DDL. I am getting unable to extend rollback segment.... error when I try to create number of stored procedures.
Thanks
Sonali
Yes they are ...
To get out of the problem you can either increase the max extent limit on the RBS
Designate some RBS to be used in the session.Code:ALTER ROLLBACK SEGMENT RBS0
STORAGE ( MAXEXTENTS UNLIMITED);
Sam
Some DBAs are for, and some against doing this. I am strongly against!Quote:
ALTER ROLLBACK SEGMENT RBS0
STORAGE ( MAXEXTENTS UNLIMITED);
quoted by julian:
------------------------------------------------------------
quote:
ALTER ROLLBACK SEGMENT RBS0
STORAGE ( MAXEXTENTS UNLIMITED);
Some DBAs are for, and some against doing this. I am strongly against!
-----------------------------------------------------------
Usually the reason is just to make sure that there
can be no transaction fail due to maxextents limit.
You can always maintain your rbs well anyway.
And I think there is no liabilities if you just set it
to unlimited.
Yes, there is: a runway transactoion may "eat" all your free tablespace.Quote:
iB]
And I think there is no liabilities if you just set it to unlimited.
[/B]
My problem is not how to increase the RB segment why is "Create Stored Procedure" using RB segement when it is a DDL ?
What is stored in RB segment for creating a stored procedure ?
If I am not wrong here, we cannot even rollback create stored procedure can we ?
To Clarify again I am not executing procedure I am just creating a stored procedure.
Thanks
Sonali
What is stored in RB segment for creating a store procedure? Well, a bunch of new/updated records in a database dictionary.
Can you ever "rollback" the creation/modification of stored procedure? No, never. DDL are executed with implict commit, so you can't roll it back.
Thanks for the reply
Sonali