RE: v$Views and d$Tables

2003-01-19 Thread Santosh Varma
Thank you very much Roberttahiti.oracle.com was really useful site..had every information in it.. santosh -Original Message- Freeman Sent: Sunday, January 19, 2003 11:54 AM To: Multiple recipients of list ORACLE-L All of these views are pretty well documented in the Oracle9i

RE: v$Views and d$Tables

2003-01-18 Thread Robert Freeman
All of these views are pretty well documented in the Oracle9i docs too. The doc's of the v$ tables is much better these days (but still isn't perfect). Check out tahiti.oracle.com. Robert -Original Message- Kirti Sent: Friday, January 17, 2003 11:40 AM To: Multiple recipients of list

Re: v$Views and d$Tables

2003-01-17 Thread K Gopalakrishnan
For V$Views definitions have a look at catalog.sql, which has some information. I understand by D$tables, you mean the dictionary tables. If that is the case, the sql.bsq (under the $ORACLE_HOME/rdbms/admin) will be of use. KG = Have a nice day !!

RE: v$Views and d$Tables

2003-01-17 Thread Santosh Varma
Thank you very much. santosh -Original Message- Gopalakrishnan Sent: Friday, January 17, 2003 1:19 PM To: Multiple recipients of list ORACLE-L For V$Views definitions have a look at catalog.sql, which has some information. I understand by D$tables, you mean the dictionary tables. If

RE: v$Views and d$Tables

2003-01-17 Thread Sony kristanto
Do you have 'EXECUTE CATALOG' previllege ? 1. Views OWNER NOT NULL VARCHAR2(30) VIEW_NAME NOT NULL VARCHAR2(30) TEXT_LENGTH NUMBER TEXT LONG TYPE_TEXT_LENGTH

RE: v$Views and d$Tables

2003-01-17 Thread Deshpande, Kirti
http://tahiti.oracle.com Look in Database Reference Guide. Or if you have Rich Niemiec's book (Performance Tuning Tips Techniques... etc..) there are a number of pagesshowing the output from 'describe' ofmany of suchviews. - Kirti -Original Message-From: Santosh Varma

RE: v$Views and d$Tables

2003-01-17 Thread Rachel Carmichael
/start of plug so does Oracle9i DBA 101 and it explains them too /end of plug I'm so ashamed, it won't happen again --- Deshpande, Kirti [EMAIL PROTECTED] wrote: http://tahiti.oracle.com Look in Database Reference Guide. Or if you have Rich Niemiec's book (Performance Tuning Tips

RE: v$Views and d$Tables

2003-01-17 Thread Deshpande, Kirti
Not a problem... I have not bought your book yet... :( And I *would* expect more useful information in your book, than just 'describes' ;) - Kirti -Original Message- Sent: Friday, January 17, 2003 10:11 AM To: Multiple recipients of list ORACLE-L /start of plug so does Oracle9i