Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Inconsistent data dictionary

Re: Inconsistent data dictionary

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 08 Oct 2005 15:36:48 GMT
Message-ID: <Xns96E957A33A2C8SunnySD@68.6.19.6>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US