| |
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? |
| December 12, 2008 11:22:06 |
#5 |
| nalinbit |
Member Since: November 2008 Total Comments: 3 |
RE: View - Base Tables
|
View just stores the query defination and not the data. if base table or any one table involed with view is dropped we will get this error in 10g
ORA-04063: view "SCOTT.VEMP" has errors
where vemp is view name |
| |
Back To Question | |
