RE: X$tables

2003-09-23 Thread A.Bahar
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

RE: X$tables

2003-09-23 Thread Jamadagni, Rajendra
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

RE: X$ tables ??

2001-05-02 Thread Suhen Pather
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

Re: X$ tables ??

2001-05-02 Thread Jared Still
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 --

RE: X$ tables

2001-04-07 Thread Norwood Bradly A
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

Re: X$ tables

2001-04-06 Thread K Gopalakrishnan
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 !!