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: missing some sys.tables

Re: missing some sys.tables

From: Frank Dietrich <ablesoft_at_gmx.de>
Date: Fri, 25 Feb 2005 08:55:22 +0100
Message-ID: <3883vbF5mn18oU3@individual.net>


Hi Mark,

Mark D Powell wrote:
> Frank, what version of Oracle are you dealing with?

We have an Oracle 8.1.7.

> On 9.2.0.5 if I login as user 'SYS' a query of dba_objects turns up
> only 5 X$ objects but I am able to query hundreds of them.

The problem was, I all the time forget to connect as sys.

Thank you
Frank Received on Fri Feb 25 2005 - 01:55:22 CST

Original text of this message

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