Hello all,

When i execute a procedure which is the part of a package i get following
error:



BEGIN actuals_pak.populate_t_spbuddef; END;

*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 12

The segment being used is 'SEGMENT R01'

If i understand correctly there is not enough resources in segment R01 to
keep all records in case if roll back occurs. Is there a way to expend
this segment ? Is there a oracle system log file ? The environment is:
Oracle 8.1 running of AIX 5.1


I am newbie in Oracle. Please advise how to rectify the problem.

Thank you in advance.


Maxim






Regards,

Maxim Ness | Database Administrator
CB Richard Ellis Management Services | Information Technology Solutions
18 King Street East, Suite 1400 | Toronto, Ontario, M5C 1C4
T 416 775 3975 x3451 | F 416 775 3989 | C 416 220 7357
maxim.[Email address protected] | www.cbre.ca

Oracle LazyDBA home page