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]';