Re: missing some sys.tables

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

Hi Rauf,

Rauf Sarwar wrote:
> Frank Dietrich wrote:

>>I think here are some fixed tables lost.
>>Following select will return 271 entries (Oracle 8i)
>>   select name from v$fixed_table where name like 'X$%';
>>
>>but this will return no entry
>>   select object_name from all_objects where object_name like 'X$%';

>
> X$ objects are hidden and are only accessable by SYS. You can't even do

---

That was the fault. I all the time forget to connect as sys.

> I wouldn't mess around with X$ objects unless like Daniel mentioned...
> if it ain't broke... then don't try to fix it.

They are not broken but wasn't accessible by the script. Now the script runs as expected.

Thank you.
Frank Received on Fri Feb 25 2005 - 01:53:34 CST