SELECT DBMS_METADATA.GET_DDL('MATERIALIZED_VIEW', 'MV_USEINDEX_CLUSTER', USER) FROM dual;

CREATE MATERIALIZED VIEW "U99"."MV_USEINDEX_CLUSTER" ("C1", "C2_CLUST")
ORGANIZATION HEAP CLUSTER "U99"."CLUSTER_NUMBER10" ("C2_CLUST")
BUILD IMMEDIATE
USING INDEX 
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE
AS SELECT 'char', CAST( 1 AS NUMBER(10) ) FROM dual