View - Base Tables

Does View occupy memory? If we delete the base table of existing view, What happens?

manu4sql
Profile Answers by manu4sql Questions by manu4sql
Oct 23rd, 2008
9
15687

Questions by manu4sql

SQL

Answer

Editorial / Best Answer

Mad Hatter

Profile Answers by Mad Hatter Questions by Mad Hatter

Member Since Nov-2008 | Nov 4th, 2008

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.

Showing Answers 1 - 9 of 9 Answers

oozaifa
Profile Answers by oozaifa

Oct 30th, 2008

If we delete the base table of view the view will prompt an error its wont execute

oozaifa
Profile Answers by oozaifa

Oct 30th, 2008

View does not occupy an actual database memory it just an virtual table once we delete the base table the view will not execute.

Mad Hatter
Profile Answers by Mad Hatter

Nov 4th, 2008

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.

laks_31
Profile Answers by laks_31

Nov 26th, 2008

Views does not occupy memory. When the base table is deleted, view also throws an error

nalinbit
Profile Answers by nalinbit

Dec 6th, 2008

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

Priya Murugesan
Profile Answers by Priya Murugesan

Aug 17th, 2009

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.

Rabindra_Kumar
Profile Answers by Rabindra_Kumar

Oct 28th, 2009

Actually view is a stored select statement and its code is stored in data dictionary. It doesn't occupy space in the memory. whenever view is called, the stored select statement executes and fetches the data from the base table.
If base table is deleted, view becomes invalid.

manimehra905
Profile Answers by manimehra905

May 18th, 2010

View does not occupy memory as it only provides a way for watching multiple views of an object: Table. Moreover, it is a virtual table which does not take space.
It provides DATA HIDING.For e.g. if an Administrator does not want his subordinates to have a view over all records then he can use view and assign the privileges of that view only to his subordinates and not of table.
If the base table is deleted then view will become inaccessible.

pkshve
Profile Answers by pkshve

Sep 12th, 2010

Views are database objects - they are just SQL code stored in database which will be executed every single time the view is called. Database will check the existance of columns and tables in the base SQL when view is created and it keep checks every single time the view is called.
When base table is deleted, DB marks the view as un usable/corrupted and raises the error when its called. The view code still remain in the database.