Re: Inconsistent data dictionary

"Klaus" <kgl_at_condat.de> wrote in
news:1128782111.715430.207340_at_g49g2000cwa.googlegroups.com:

> Hallo,
>
> I have a inconsistent data dictionary and I am not sure how to resolve
> it.
>

So.
Why do you feel you are compelled to resolve anything?

> After our customer dropped a user and lost network connection while
> doing it, we have some strange entries in obj$.
>
> I would think, that the statement:
>
> select *
> from sys.obj$
> where owner# not in (select user# from sys.user$)
>
> should always deliver 0 results. But we find 317 objects belonging to
> owner#=5502. Type# is 4 and 5 (not 10!).
>
> Is this a problem?

I don't think it is a problem.

> Can I just delete those entries?

What harm are they doing to the application(s)?

> How can I find out more about the problem?

Problem?
What problem?
What error message(s) are you seeing? Received on Sat Oct 08 2005 - 10:36:48 CDT