DESCRIBE EXTENDED and DESCRIBE FORMATTED
You can get extensive formatted and unformatted information about a materialized view.
Syntax
DESCRIBE [EXTENDED | FORMATTED] [db_name.]materialized_view_name;- db_name
- The database name.
- materialized_view_name
- The name of the materialized view.
Example
DESCRIBE FORMATTED mydb.mv1;