Re: Question about USER_ERRORS

In article <a5p479$e73$1_at_bob.news.rcn.net>, "RKG" says...
>
>How long do errors stay in this view? Do they get archived or deleted after
>a while? The project Im on is not setting up individual schemas(I have no
>say in this) and our user_error view is growing and growing.... If multiple
>errors come in on the same object will it write over the old ones? how do
>you tell which ones are newer?
>
>
>
>

as long as an object is in error -- its errors will be in there.

when it compiles clean -- they'll be deleted.

every compile deletes the old errors and inserts new. You need not tell which are "newer", only the last persist.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp