| |
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? |
| August 08, 2009 10:55:24 |
#6 |
| Priya Murugesan |
Member Since: August 2009 Total Comments: 2 |
RE: View - Base Tables
|
View is a named SQL query stored in data dictionary. View itself does not
contain any data, the execution of view retrieve data from base table (s).
If base tables are deleted, the following error will be reported.
ERROR at line 1:
ORA-04063: view "SCOTT.EMP1_VIEW" has errors
We can get the successful execution of view by recreating the related base
tables.
|
| |
Back To Question | |
