| Invalid Views [message #374792] |
Mon, 02 July 2001 20:35  |
Heidi
Messages: 37
Registered: February 2000
|
Member |
|
|
|
Does anyone have a complete list of what would make a view's status change to INVALID? I created a view without errors, did not change any underlying tables, the view doesn't use any functions and now suddenly it's INVALID. When I select from this INVALID view, it's status becomes VALID. Any idea why?
|
|
|
|
|
|
| Re: Invalid Views [message #374801 is a reply to message #374792] |
Tue, 03 July 2001 07:37  |
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
|
Member |
|
|
I think the view will become invalid when:-
1) We create a view without a table with force option,it will
be invalid.But once we create the table, oracle will automatically
check the status of the view to ensure that we select from the
view without recompiling.
2) When the underlying base structure is changed,which effects the
view, then it will become invalid.
Regards,
Giridhar Kodakalla
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
