Home » RDBMS Server » Server Administration » x$ tables
x$ tables [message #55615] Tue, 04 February 2003 10:48 Go to next message
Kathleen
Messages: 3
Registered: August 2000
Junior Member
Are the X$ tables not visible in oracle 7.3 ?
Although connected as sys, they seem to not exist.

Report message to a moderator

Re: x$ tables [message #55661 is a reply to message #55615] Fri, 07 February 2003 00:23 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
They are there. All V$ and DBA_, ALL_, USER_ views are based on them.

To see them run this query:

SQL> select name from V$FIXED_TABLE;

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: deleting a datafile of Rollback segment
Next Topic: Oracle 9i Installation problem - No Jre !
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:52:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.