Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: missing some sys.tables
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