Materialized Views


Run the code on this page to drop the sample tables, procedures, etc. created in earlier parts of this section. To clear session state changes (e.g. those made by SET, COLUMN, and VARIABLE commands) exit your SQL*Plus session after running these cleanup commands.

Be sure to read Using SQL Snippets ™ before executing any of these setup steps.

drop table t2 ;
drop table t ;

drop table t_backup ;
drop table t2_backup ;

drop function my_mv_capabilities ;
-- MV_CAPABILITIES_TABLE is an Oracle table; do not drop it from your schema
-- unless you specifically created it for this tutorial and no longer wish to
-- use it

drop table mv_capabilities_table ;

Linking to SQL Snippets ™

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

  • [url=]SQL Snippets: Materialized Views - Cleanup[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

  • <a href="">SQL Snippets: Materialized Views - Cleanup</a>

To link to this page in other web sites use the following values.

  • Link Text : SQL Snippets: Materialized Views - Cleanup
  • URL (href):