create materialized view log INCLUDNG NEW VALUES;

From: "Thomas Day" <tomday2@xxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 9 Oct 2006 10:32:56 -0400

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

Follow-Ups:
- Re: create materialized view log INCLUDNG NEW VALUES;
  - From: Ghassan Salem
- Re: create materialized view log INCLUDNG NEW VALUES;
  - From: Niall Litchfield
- Cloning database structure
  - From: Prabhu, Krishnaswamy

create materialized view log INCLUDNG NEW VALUES;

Other related posts: