Oracle Materialized View DDL

Posted on Nov 9, 2005 in Technical Tips | 0 comments



Are you a TOAD fanatic when it comes to “anything-Oracle”? If so, you probably realized that TOAD will not show you the DDL for a materialized view in any of the tabs in the schema browser. The “Scripts” tab will look similar to a table’s script.

Following is an SQL statement you can run to find out the SQL used by the materialized view:

1

SELECT query FROM user_mviews WHERE mview_name='[MV_NAME]';

Enjoy!

Bookmark and Share

Related Information:

  1. Oracle Materialized View Manual Refresh
    Following is the call that...
  2. TOAD SQL Editor Useful Shortcuts
    SHIFT-F9 This will run only...
  3. Oracle Rename Table – Example Syntax and Dependencies
    Renaming a table in Oracle...
  4. Oracle Rename Column – alter table, rename column Example SQL Syntax
    Following is simple example syntax...
  5. TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open
    I recently downloaded the new...
  6. Oracle SQL Subselect Statements
    It is becoming more common...
  7. Oracle Autoincrement
    Unlike Oracle, other less expensive...
  8. alter table, add column – Oracle Example Syntax
    Following is simple example syntax...

Leave a Reply