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
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:
HI
