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

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 ??

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-05-02 Thread Mark Leith
You will need to either be connected as SYS or SYSDBA: SQL> connect sys/password Connected. SQL> desc x$bh Name Null?Type - ADDR RAW(4) IND

Re: X$ tables ??

2001-05-02 Thread Brijesh Lal
X$ views can be seen only in sys, internal or system account or in user account having select any table previledge are u looking for x$ views in any of these users --- "Bunyamin K.Karadeniz" <[EMAIL PROTECTED]> wrote: > I see that there is no X$ tables in my database or > I can not view them . My

RE: X$ tables ??

2001-05-02 Thread Mark Leith
You will need to either be connected as SYS or SYSDBA:   SQL> connect sys/password Connected.   SQL> desc x$bh  Name  Null?    Type  -  ADDR

RE: X$ tables ??

2001-05-02 Thread Suhen Pather
Bunyamin,   You should be able to view these tables from 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 / Informa

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 site

RE: X$ tables

2001-04-07 Thread Nihar
Title: X$ tables v$fixed_tables   v$views       - NIHAR SANGHVINetMagic Solutions Pvt. Ltd.22,Nirlon Complex,Western Express Highway,Goregaon (E), Mumabai 400 063Phone: 8723003 extn: 144www.netmagicsolutions.com  -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE

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 !! B