I'm not sure if probing the sga would work - its
common in systems that do a lot of parsing to see many
calls to view$ in trace files (for the same view) -
leading to the hypothesis that view defn's are not
cached.
hth
connor
- "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU>
wrote: > If it's only aliases you need to worry about
you can
> get the view text and use dbms_sql.parse and
> dbms_sql.describe_columns to get the names. However
> if the column in the view is involved in a function
> or perhaps used in conjunction with another
> column, then this method does not work.
>
> There was an admittedly ugly suggestion of" getting
> the view names from one of the dependencies tables;
> renaming the table containing the column of
> interest; creating another table with the same name
> and structure as the original one but with the
> column missing, and then checking to see which
> views became invalid. I wouldn't do that on a
> production system.
>
> One would think that once a view has been parsed,
> Oracle would hold that somewhere in memory. I don't
> know the X$ structures well enough. Perhaps it
> isn't accessible. Perhaps one needs to dump the
> SGA.
>
> It looks like the real answer is to write your own
> parser.
>
> Ian MacGregor
> Stanforfd Linear Accelerator Center
> ian_at_slac.stanford.edu
>
> -----Original Message-----
> Sent: Thursday, April 11, 2002 2:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> This won't work if I alias the column name in the
> view definition, would it?
>
> Raj
>
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't
> reflect that of ESPN Inc.
>
> QOTD: Any clod can have facts, but having an opinion
> is an art!
>
>
> -----Original Message-----
> Sent: Thursday, April 11, 2002 5:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Darn E-mail package. Every once in a while I get a
> message as I'm deleting
> one
> or more I don't want & one I do want goes as well.
> Well, I guess that's
> IBM/Lotus for you.
>
> Anyway, someone asked how to find all the views that
> include a specific
> column.
> Try the following:
>
> select view_name
> from user_views, user_tab_columns
> where view_name = table_name
> and column_name = '<fill_in_the_blank>';
>
> Dick Goulet
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> 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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Mon Apr 15 2002 - 04:03:22 CDT
