>when i run a job i get the error as failed to increase the rollback segment. what should i do
The simple answer is to re-size the rollback segment
ALTER ROLLBACK SEGMENT
STORAGE (
NEXT 40960
)
This should do it.
Also may I recommend joining www.lazydba.com. This is a great forum for Oracle DBAs.
HTH,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!