Hi john,
Did you check the parametrs right.And any event parameter in your init.ora file
Check and reply soon
Chhers
Ganti
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
The error happens on the create statement. The sql works fine if the MV is is the
same instance. As soon as I try to create the MV on seperate
instance thru a link , I get an ORA-12054: cannot set the ON COMMIT refresh attribute
for the materialized view.
[EMAIL PROTECTED] wrote:
>
>
> H
HI JOHN,
What exactly the error.Please be more specific.Was the MV created. Or after
creation of MV after some interval (The interval specified while creating MV)
you didn't see the refreshed data.I suppose that must be so..
Check Job_queue_processes,Job_queue_interval parameters in your init.