Re: Metadata for Views

From: HansF <News.Hans_at_telus.net>
Date: Mon, 13 Feb 2006 16:42:02 GMT
Message-Id: <pan.2006.02.13.16.42.01.817754@telus.net>

On Sun, 12 Feb 2006 13:48:57 -0800, sirvinay wrote:

> We have many views in our database
> if I want to change a logic of a column in my databse or increase the
> length of a column, i have to find what are the other objects impacted
> For this I hae to manually open the LOB for each view and search for
> the column name I am planning to change
> This is a very time taking process becasue i have to search almost 100
> views
>

Can the information in ?_DEPENDENCIES help in your case?

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Mon Feb 13 2006 - 10:42:02 CST