| Compilation of Packages [message #55008] |
Thu, 26 December 2002 04:38  |
G Raghunath
Messages: 8
Registered: November 2002
|
Junior Member |
|
|
Are Rollback Segments used while compilation of packages.
I am aksing this because i got an error :-
"Unable to extend Rollback Segment" message while compiling a package.
Any help on this is highly appreciated.
|
|
|
|
| Re: Compilation of Packages [message #55091 is a reply to message #55008] |
Thu, 02 January 2003 17:01  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Yes, rollback segments are used when compiling any data dictionary objects. That involves chamging the data dictionary and unless the compilation succeeds (which means implicit commit), Oracle uses rollback segments to store the before image.
So increase the RBS size, or for this package compilation use didicated RBS:
SQL>SET TRANSACTION USE ROLLBACK SEGMENT rbs_big_name;
SQL>.... compile your package
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
