control file
-Original Message-
Sent: Tuesday, September 23, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have a doubt,please clarify.
All we know about x$tables(fixed tables) and
these all are in-memory table.When instance startup the data will be brought
back in this
Title: RE: X$tables
x$tables/views are nothing but a clever implementation of SGA C structures as virtual tables. This is also in line with the RDBMS that all metadata etc should be accessible from tables.
Raj
Bunyamin,
You should be able
to view these tablesfrom the SYS
schema.
Regards
Suhen
I see that there is no X$ tables in my
database or I can not view them . My O.S. is NT .
How can I view them.??
Thanks
Bunyamin K.Karadeniz
Database Group / Information Systems
On Wednesday 02 May 2001 08:30, Mark Leith wrote:
You will need to either be connected as SYS or SYSDBA:
Well, you can easily remedy that.
http://www.ixora.com.au/scripts/sql/create_xviews.sql
Courtesy of Steve Adams.
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
You might also peruse this area:
http://www.oreilly.com/catalog/orinternals/desc.html
-Original Message-
Sent: Friday, April 06, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Hi !
There is no document about X$tables outside oracle.
But Steve Adams has some details in his
Hi !
There is no document about X$tables outside oracle.
But Steve Adams has some details in his site
(http://www.ixora.com.au) and Jonathan Lewis also
something in his site (http://www.jlcomp.demon.co.uk).
=
Have a nice day !!