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.