Where is the error in this Materialized Views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Where is the error in this Materialized Views

  1. #1
    Join Date
    Mar 2001
    Posts
    188
    Hi there,
    is any error.

    CREATE MATERIALIZED VIEW MV_TEST
    BUILD IMMEDIATE
    ENABLE REWRITE
    REFRESH ON DEMAND
    AS
    SELECT rowid, stime_id,
    FROM TEST

    ORA-02000 Missing string keyword


    Whats wrong???

    Thanks very much
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    correct syntax is :
    ... ENABLE *QUERY* REWRITE ...

  3. #3
    Join Date
    Mar 2001
    Posts
    188
    CREATE MATERIALIZED VIEW MV_TRAFFICBASE
    BUILD IMMEDIATE
    ENABLE QUERY REWRITE
    REFRESH ON DEMAND
    AS
    SELECT rowid, stime_id,
    FROM TEST

    ORA-00905 Missing keyword

    Whats up, it doesn't run. the following error occurs
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width