Oracle Materialized View DDL

By M&S Consulting (Ashok) on Nov 9th, 2005
Filed Under Technical Tips // Tags:

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 can be made to refresh your materialized view in Oracle manually: 1 execute DBMS_SNAPSHOT.REFRESH('[MV_NAME]','[refresh_option]'); Refresh...
  2. 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 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x,...
  3. Oracle Rename Table - Example Syntax and Dependencies
    Renaming a table in Oracle is simple. Following is the generic Oracle table rename syntax: 1 ALTER TABLE current_table_name RENAME...
  4. Oracle BPEL Email Notification - Remove Attachment
    If you have used the email notification activity in Oracle BPEL (up through the latest version at the time of...
  5. Google Apps Reporting API - Not quite this easy with Exchange
    I have been somewhat enamored by Google Apps and its potential. Many enterprises have been happy with Exchange for mail,...
  6. Oracle IdM - SAML SSO with Google Apps
    We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against...
  7. Oracle Rename Column - alter table, rename column Example SQL Syntax

    Following is simple example syntax for renaming a column to an Oracle table using "alter table" SQL:

    ALTER...

Leave a Reply


Archives

Recent Comments

  • Tony Hale said: What a great resource these videos are! These are all very helpful. Anything you can do to popularize...
  • Mohammed said: Hello, Thanks for the tutorial, but I’ve noticed that the link isn’t setup right,...
  • shekar said: thanks mate, you saved my day… the link is still working….
  • romit said: thnx a lot.. i had been searching for this link from last 4 days. and was just about to quit my search...
  • Ram said: By the way, FB 4 includes both SDK 4 and 3. Therefore if you are looking for FB 3, download FB 4 and point...

Calendar

September 2010
M T W T F S S
« Jul    
 12345
6789101112
13141516171819
20212223242526
27282930  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service