Oracle Materialized View DDL

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!

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

Your email address will not be published. Required fields are marked *