user11978001 wrote:Not really sure about your MV refresh interval. What do you expect "trunc(sysdate)+1+3.75/24" to evaluate to ? Do you want the MV to be refreshed every day at a certain time? Without brackets, I am not sure if that expression means the same (as you expect). What do you see for INTERVAL and NEXT_DATE and BROKEN for this MV refresh job?
Why is this DELETE statement running, when I said REFRESH on demand? Is this running since the MV was created?
On the other hand, the database is shutdown/startup everyday at 8pm/10pm, and there has not been any problem with this shutdown/startup, so I can't understand why this Delete statement is still running.
The MV has now a compilation error status, why is not possible to drop it then?
Can anybody help me?
user11978001 wrote:You can try
When I try to kill the session I get this:
Error starting at line 1 in command:
alter system kill session '261,1408'
alter system disconnect session 'SID,SERIAL' immediate;
Every time I run the command to kill the session and apears again the next day :\Evidently, this job manage your MV. What do you want, remove the MV or use it? If to use then what's wrong?