Materialized view commands
Also available as:
PDF

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;