I think the WHERE clause may be the problem.
have you defined your log to keep copies of the
OLD and NEW values for POINT_TYPE ?
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Suzanne Edgecombe wrote in message ...
>Hi All,
>
>Im trying to create a simple materialized view thus:
>
>
>create materialised view timepoints
>
>refresh fast on commit
>
>as select * from ozmar.marineobs
>
>where point_type = 1
>
>
>
>I have already created the view log OK. When I run this, it comes up with
>ORA-12054, cant set the on-commit part of the view and basically specify
>only legal options. The only info I can find is that you cant refresh on
>commit if there are calculations in the view SQL. What else in my syntax
>may cause this error?
>
>
>
>Many thanks for your help
>
>
>
>Cheers
>
>Sue Edgecombe
>
>
>
>
>
>
>I
>
>
>
Received on Fri Sep 14 2001 - 15:14:18 CDT
