Recompile schema

Hi

I have been using the dbms_utility.recompile_schema procedure, but keep getting errors about 'snapshot too old' in one of my rollback segments, even tough I set transaction at the start of the script. (Why is it using rollback anyway ?)

Have anybody had this problem, what are the workrounds ?

Any help appreciated.

--
Regards Richard Platt
rick.platt_at_btinternet.com Received on Sun Oct 03 1999 - 06:35:07 CDT