Originally posted by pravin karne:
There is nothing related to job in trace file and alertlog file...
When I perform DML operations on Master table, MV log populates with data but SNAPTIME$$ always
contains '1/1/4000' date. Also after running it's job manually MV refreshes with new values but
when job runs automatically then MV is not refreshing...
What will be the problem?
I am using Snapshot replication for remotely located table.
Any idea?
Thanks...
Pravine, if there is nothing in the log (
you should also check snapshot log) related to the job running and the materialized view is not refreshed... how do you know the automatic job is even being initiated? How is this job triggered?