Re: create materialized view log INCLUDNG NEW VALUES;

Thomas,
just tried this on a 10gR2 (I don't have access to a 8i) create materialized view log on products tablespace benchdata including new values;

and it worked
rgds

On 10/9/06, Thomas Day <tomday2_at_gmail.com> wrote:
>
> 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