compile invalid view [message #656530] |
Mon, 10 October 2016 10:20 |
desmond30
Messages: 41 Registered: November 2009
|
Member |
|
|
I have increased size of a column in a table, there is a view that uses this table, which is of course invalid, the strange problem i am facing is,
when I try to compile the view / or create or replace the view again, its taking a lot of time to compile,
So the question is, when a view is created (create or replace view) or when I compile an invalid view, is the sql behind the view gets executed ?
Because there is a lot of data for sure
|
|
|
|
Re: compile invalid view [message #656532 is a reply to message #656530] |
Mon, 10 October 2016 10:26 |
cookiemonster
Messages: 13920 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Unless it's a materialized view, no. All that happens is that the view is parsed to make sure it's syntactically correct and the data dictionary is updated.
|
|
|
|
|
|