2 Replies Latest reply on Aug 28, 2007 3:51 AM by 582246

    ORA-00905: missing keyword error while creating a materialised view

    582246
      Hi Gurus,

      I am trying to create a materialized view as :
      1 CREATE MATERIALIZED VIEW AMREG.ClientData
      2 TABLESPACE AMREG_DATA
      3 COMPRESS
      4 PARALLEL
      5 NOLOGGING
      6 BUILD IMMEDIATE
      7 REFRESH COMPLETE
      8 ON DEMAND
      9 DISABLE QUERY REWRITE
      10 REFRESH START WITH TRUNC( SYSDATE + 1 ) + 3/24 NEXT TRUNC( SYSDATE + 1 ) + 3/24
      11 AS
      12 SELECT
      13 CHILD.CLIENT_SGK "Child SGK",
      14 CHILD.CLIENT_NAME "Child Name",
      15 CHILD.ARC_ACCT_CD "Child ARC Acct Code",
      16 ULTIMATE.CLIENT_SGK "Ultimate Parent SGK",
      17 ULTIMATE.CLIENT_NAME "Ultimate Parent Name",
      18 ULTIMATE.ARC_ACCT_CD "Ultimate ARC Acct Code",
      19 HIER.LVL_FROM_ANCESTOR ,
      20 FROM Ref_Schema.CLIENT_REF@DNYCPH60.WORLD CHILD,
      21 Ref_Schema.CLIENT_ACCT_ULT_GLB_HIER_REF@DNYCPH60.WORLD HIER,
      22 Ref_Schema.CLIENT_REF@DNYCPH60.WORLD ULTIMATE
      23 WHERE HIER.DESCENDANT_CLIENT_SGK = CHILD.CLIENT_SGK
      24* AND ULTIMATE.CLIENT_SGK = HIER.ANCESTOR_CLIENT_SGK;
      SQL> /
      REFRESH START WITH TRUNC( SYSDATE + 1 ) + 3/24 NEXT TRUNC( SYSDATE + 1 ) + 3/24
      *
      ERROR at line 10:
      ORA-00905: missing keyword

      DBLink name is : DNYCPH60.WORLD

      Please guide me on this and help to resolve the issue.