create materialized view log INCLUDNG NEW VALUES;

From: Thomas Day <tomday2_at_gmail.com>
Date: Mon, 9 Oct 2006 10:32:56 -0400
Message-ID: <a8c504590610090732o10ca03a8g986d088c2bf6b86b@mail.gmail.com>

I've copied the example from the SQL Reference 9.2

CREATE MATERIALIZED VIEW LOG ON sales

   WITH ROWID, SEQUENCE(amount_sold, time_id, prod_id)    INCLUDNG NEW VALUES; But when I run it on our AIX, oracle 9.2 system I get:

CREATE MATERIALIZED VIEW LOG ON ADDRESSES tablespace dss_data INCLUDNG NEW VALUES

                                                              *

ERROR at line 1:
ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option

Now. is the manual lying or do I need some other syntax?

Thanks

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 09 2006 - 09:32:56 CDT