ORA-01555: snapshot too old: rollback segment number 26 with name "_SYSSMU26$" too small
I am getting this error in procedure that procedure is using cursor.proc took 10 hrs to complete.
for one record i have got this error.I am using 10g. Tables have been analyzed properly before running this proc.Please let us know if there is posisible solution to this.Database is used by many users. WHats main cause for this error??