Re: Question about USER_ERRORS

Well I got the answer I was looking for from another poster and actually it is a valid question. Your response was extremely short sited. I generally develop in my own schema and then later move my database objects to the 'main'(I dont know the industry term for this) that the application is run on. On my current project, management does not want to be bothered with allowing every developer have his or her own schema. I have no say in this decision.

Therefore everyone is developing in one joint schema. Therefore when I had a compilation error and checked user_errors I noticed 85 errors in the view. Since I generally develop in my own schema I never thought about exactly what is in the table that this view is based on. Was it a log? Or was it just items that were 'in error' as Tom called them. So I wondered when or how they were filtered out. Im not a DBA, so Im not an expert in the data dictionary.

"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message news:3C801DC2.57A8915D_at_ci.seattle.wa.us...
> Nothing you have said has even the remotest relationship with anything I
have
> ever heard of involving to Oracle.
>
> Please give some serious consideration to what it is you are doing and
asking
> and try again.
>
> Daniel Morgan
>
>
> RKG wrote:
>
> > 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?
>
Received on Fri Mar 01 2002 - 19:32:56 CST