On Wed, May 5, 2010 at 7:31 AM, Thom Brown wrote:
> On 5 May 2010 13:14, Chris Barnes wrote:
>>
>> It has been some years since I worked with Oracle, doesn't Oracle
>> recompile the view when the object it references changes in structure?
>> Send
>
> What does Oracle do when you've got a view lik
2010/5/5 Sim Zacks :
> One of the biggest problems I have maintaining a database with a lot of
> views is that when I want to change a datatype, I have to drop every
> view uses the column and every view that uses those views etc...
> This turns into a maintenance nightmare.
Then I would question
On 5 May 2010 13:14, Chris Barnes wrote:
>
> It has been some years since I worked with Oracle, doesn't Oracle recompile
> the view when the object it references changes in structure?
> Send
>
What does Oracle do when you've got a view like:
CREATE OR REPLACE VIEW test_view AS
SELECT test.test
It has been some years since I worked with Oracle, doesn't Oracle recompile the
view when the object it references changes in structure?
Send
From: thombr...@gmail.com
Date: Wed, 5 May 2010 10:12:34 +0100
Subject: Re: [GENERAL] alter table alter type CASCADE
To: s...@compulab.co.
2010/5/5 Sim Zacks
> One of the biggest problems I have maintaining a database with a lot of
> views is that when I want to change a datatype, I have to drop every
> view uses the column and every view that uses those views etc...
> This turns into a maintenance nightmare.
>
> Is there any intent
One of the biggest problems I have maintaining a database with a lot of
views is that when I want to change a datatype, I have to drop every
view uses the column and every view that uses those views etc...
This turns into a maintenance nightmare.
Is there any intention of adding a CASCADE to alter
