Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to create Materialized View in oracle 11.2.0.4

Sadiq AliNov 13 2015 — edited Nov 13 2015

Hi, my code is here

CREATE MATERIALIZED VIEW IMAGE.FIRST_PRODUCTION_STAGE_MV (ORDER#,ITEM#,BUNDLE#,PIECES,STAGE#,START_DATE,UNIT#)

TABLESPACE USERS

PCTUSED    0

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          64K

            NEXT             1M

            MAXSIZE          UNLIMITED

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

            FLASH_CACHE      DEFAULT

            CELL_FLASH_CACHE DEFAULT

           )

NOCACHE

NOLOGGING

NOCOMPRESS

NOPARALLEL

BUILD IMMEDIATE

REFRESH COMPLETE ON DEMAND

WITH PRIMARY KEY

AS

SELECT w.order#,

       w.item#,

       w.bundle#,

       w.pieces,

       w.stage#,

       w.creation_date start_date,

       w.unit#

  FROM abc w, xyz is2, cde oe

WHERE    w.pieces  > 0

       AND  w.item# = is2.item#

       AND w.stage# = is2.stage# + 1

       AND is2.sname = 'INDUCTION'

       AND SUBSTR (w.order#, 1, 7) = oe.order#;

ORA-12018: following error encountered during code generation for "IMAGE"."FIRST_PRODUCTION_STAGE_MV"

ORA-00904: : invalid identifier

please help me to resolve this.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2015
Added on Nov 13 2015
11 comments
616 views