How to remove ALL_ERRORS records

Hello All,

I would like to add some checks into scripts updating database meta-data to ensure no records were inserted into the ALL_ERRORS view.

My problem is that there are some old records in this view that I can't remove by simply correcting the errors. For example there is a package body error record complaining that ...

PLS-00305: previous use of 'STRUCTURE_CODES' conflicts with this use

STRUCTURE_CODES is an existing table name which I need to keep.

I'm assuming I shouldn't mess with the a system table and delete records from the underlying sys.error$ table!

Any help would be much appreciated

Dan Osborne
Specialist Business Solutions Ltd.

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful