| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: View - Base Tables
Answer: Does View occupy memory? If we delete the base table of existing view, What happens? |
| November 11, 2008 17:49:16 |
#3 |
| Mad Hatter |
Member Since: November 2008 Total Comments: 5 |
RE: View - Base Tables
|
View does not occupy memory, but Oracle keeps view code in its dictionary (you can check in user_views, for example)
If you delete the base table, the view becomes INVALID.
In order to make it valid again, you have to ether build the deleted table again, or create anotehr view with the same name and structure as deleted table, or create synonym with the same name as deleted table, which will point to the table with the same structure. |
| |
Back To Question | |
