>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!!