Oracle Materialized View DDL

AshokTechnical Tips1 Comment

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:

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


One Comment on “Oracle Materialized View DDL”

  1. What’s up, I desire to subscribe for this website to obtain most recent updates, thus where can i do it please help.

Leave a Reply to Cory Gramp Cancel reply

Your email address will not be published.