Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: create materialized view log INCLUDNG NEW VALUES;

Re: create materialized view log INCLUDNG NEW VALUES;

From: Ghassan Salem <salem.ghassan_at_gmail.com>
Date: Mon, 9 Oct 2006 16:43:28 +0200
Message-ID: <411d50f60610090743w2d6bd623q8aabf54c0e889dba@mail.gmail.com>


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
Received on Mon Oct 09 2006 - 09:43:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US