"Klaus" <kgl_at_condat.de> wrote in message
news:1128782111.715430.207340_at_g49g2000cwa.googlegroups.com...
> Hallo,
>
> I have a inconsistent data dictionary and I am not sure how to resolve
> it.
>
> 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? Can I just delete those entries? How can I find out
> more about the problem?
>
> Thanks
> Klaus
>
Call support. Don't try editing the table.
Jim
Received on Sat Oct 08 2005 - 10:06:24 CDT
