Using the Formatter to format a Create Materialized View command, errors to the following message:
ERROR line 26, col 1, ending_line 26, ending_col 10, Found 'NOPARALLEL', Expecting: AS -or- DISABLE ENABLE -or- FOR -or- NEVER REFRESH -or- USING -or- ALLOW BUILD COLUMN DISALLOW ELEMENT LOB NESTED PARTITION VARRAY XMLSCHEMA XMLSCHEMAS XMLTYPE
Example of command:
CREATE MATERIALIZED VIEW mview_abc
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64 K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
WITH PRIMARY KEY
AS
SELECT * FROM abc;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center