Oracle Database Discussions

Hi,

I have a group of tables to refresh one time per hour (starting at 7h00 and stopping at 19h00) every days of the week. Sometimes, I've got the following messages:

SQL> begin
2 DBMS_SNAPSHOT.REFRESH ('ATQ.proprietes_anilots');
3 end;
4 /
begin
*
ERREUR at line 1 :
ORA-12008: error in materialized view refresh path
ORA-12801: error signaled in parallel query server P001
ORA-01008: not all variables bound
ORA-02063: preceding 2 lines from ATQPROD.WORLD
ORA-06512: "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: "SYS.DBMS_SNAPSHOT", line 2429
ORA-06512: at line

SQL>

It's not always on the same table but it's often the table named below. Frequently, the refresh of the same MVIEW in problem works the hour after (without doing anything). I tried different things (disable dml parallel, disable ddl parallel, etc.). Unfortunately, if I reboot the database host of this table, usually, the refresh works after and the problem seems to be solve for a couple of weeks.

But this times, I tried the same thing and it doesn't work.

Any idea ?

Thank's in advance.