RE: Data Dictionary View for View Columns?

I don't have a "maintenance window" at work... I do what I have to do, as I have time to do it. I have at least 14 major projects on my list of things to do. As the only permanent dba where I am I work on ALL applications.

At a recent staff meeting I told everyone that I was now responding to "he who screams last and loudest"

This weekend will be MY maintenance window... for my spirit and soul and body

>From: "Thapliyal, Deepak" <DThapliyal_at_ea.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Data Dictionary View for View Columns?
>Date: Sat, 19 Aug 2000 04:33:58 -0800
>
>why did they ever come up with the concept of "maintainance window"!!
>
>-----Original Message-----
>Sent: Saturday, August 19, 2000 4:45 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Ari, I don't know about you, but besides giving you the wrong answer (I did
>know it was dba_tab_columns, sheer exhaustion, it's been a hellacious
>week)....I've been messing up my work laptop -- to the point I can't even
>log onto it.
>
>Think someone was trying to tell me I was NOT supposed to work this
>weekend?
>
>
>
>
> >From: Ari D Kaplan <akaplan_at_interaccess.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Data Dictionary View for View Columns?
> >Date: Fri, 18 Aug 2000 19:05:01 -0800
> >
> >Hi Rachel
> >
> >(What are we doing on Friday night, oy!)
> >
> >Unfortunately, DBA_TABLES does not contain information on views. I found
> >out from the list that DBA_TAB_COLUMNS (and
> >ALL_TAB_COLUMNS/USER_TAB_COLUMNS)
> >contain information on view columns.
> >
> >Someone on the list said (with a sigh) that COL does include views, but I
> >still cannot get it to work:
> >
> >SELECT * FROM COL WHERE TNAME='ALL_VIEWS';
> >
> >no rows selected
> >
> >SELECT * FROM COL WHERE TNAME='DBA_TABLES';
> >
> >no rows selected
> >
> >This will work from ALL_TAB_COLUMNS:
> >
> >SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'DBA_TABLES';
> >(many rows returned)
> >
> >Also, looking at the "sql.bsq" I was able to deduce info on the COL$ and
> >OBJ$ that includes view column information.
> >
> >Take care, and thanks again to everyone's input today.
> >
> >-Ari Kaplan
> >Independent Oracle DBA Consultant
> >
> ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> ><-> For 380+ Oracle tips, visit: <->
> ><-> <->
> ><-> www.arikaplan.com <->
> ><-> <->
> ><-> email: akaplan_at_interaccess.com <->
> ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> >
> >On Fri, 18 Aug 2000, Rachel Carmichael wrote:
> >
> > > Ari,
> > >
> > > dba_tables
> > >
> > >
> > > Rachel
> > >
> > >
> > > >From: Ari D Kaplan <akaplan_at_interaccess.com>
> > > >Reply-To: ORACLE-L_at_fatcity.com
> > > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > >Subject: Data Dictionary View for View Columns?
> > > >Date: Fri, 18 Aug 2000 10:49:25 -0800
> > > >
> > > >Does anyone know the data dictionary view (or table) that has the
>list
> >of
> > > >the columns and datatypes that comprise a view? I can get the syntax
> >for
> > > >the view's SQL (in ALL_VIEWS, VIEW$) and the number of columns
>(VIEW$),
> > > >but not the actual individual columns and datatypes.
> > > >
> > > >I am looking for something similar to COL but for views, and am
>coming
> >up
> > > >empty.
> > > >
> > > >Thanks,
> > > >
> > > >-Ari
> > > >
> > > >--
> > > >Author: Ari D Kaplan
> > > > INET: akaplan_at_interaccess.com
> > > >
> > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > >San Diego, California -- Public Internet access / Mailing
>Lists
> > > >--------------------------------------------------------------------
> > > >To REMOVE yourself from this mailing list, send an E-Mail message
> > > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > >the message BODY, include a line containing: UNSUB ORACLE-L
> > > >(or the name of mailing list you want to be removed from). You may
> > > >also send the HELP command for other information (like subscribing).
> > >
> > >
>________________________________________________________________________
> > > Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com
> > >
> > > --
> > > Author: Rachel Carmichael
> > > INET: carmichr_at_hotmail.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >--
> >Author: Ari D Kaplan
> > INET: akaplan_at_interaccess.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Author: Thapliyal, Deepak
> INET: DThapliyal_at_ea.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Sat Aug 19 2000 - 12:26:22 CDT