Answered Questions

  • Oct 23 2008
    09:45 AM
    15343
    23

    View - Base Tables
    • manu4sql

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

    Star Read Best Answer

    Editorial / Best Answer

    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.

    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 ...