1
0
0
0
1
1
1
0
9999999999
0
\{]`
0
0
0
0
0
0
0
0
0
CREATE
MATERIALIZED VIEW
CREATE MATERIALIZED VIEW "
"."
"
OF "
"."
"
(
INDEX
0
0
1
)
;
ALTER
MATERIALIZED VIEW
ALTER MATERIALIZED VIEW "
"."
" COMPILE
;
ORGANIZATION INDEX
COMPRESS
NOCOMPRESS
0
ORGANIZATION HEAP
ON PREBUILT TABLE
WITH REDUCED PRECISION
WITHOUT REDUCED PRECISION
BUILD DEFERRED
BUILD IMMEDIATE
USING NO INDEX
USING INDEX
NEVER REFRESH
REFRESH
ON DEMAND
ON COMMIT
START WITH sysdate+
NEXT
WITH PRIMARY KEY
WITH ROWID
USING
DEFAULT MASTER ROLLBACK SEGMENT
MASTER ROLLBACK SEGMENT
LOCAL ROLLBACK SEGMENT
DEFAULT LOCAL ROLLBACK SEGMENT
USING TRUSTED CONSTRAINTS
USING ENFORCED CONSTRAINTS
FOR UPDATE
DISABLE QUERY REWRITE
ENABLE QUERY REWRITE
AS
UNDER "
"."
"
USING ("
", (10, '
", (9, '
", (8, '
", (5, '
',
,
,
, "
", "
", '
',
,
, '
', '
',
3
1
2
0
, '
'
, '
'
,
,
, "
"
, NULL
, (
, "
", "
",
,
,
)
),
,
,
LOB '
',
UPDATE "
",
('
',
,
,
,
,
,
,
,
, NULL
, "
"
, NULL
, "
"
, NULL
)
, '
')
)
NEVER REFRESH
REFRESH
WITH PRIMARY KEY
FOR UPDATE
AS