Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> create materialized view log INCLUDNG NEW VALUES;
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:
Now. is the manual lying or do I need some other syntax?
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 09 2006 - 09:32:56 CDT
![]() |
![]() |