Symptoms:
定时刷新Job执行报错如下，
ORA-12012: 自动执行作业 34 出错
ORA-23404: 刷新组 "SCOTT"."TT_ORDER_HEADERS_ALL" 不存在
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.DBMS_REFRESH", line 23     ORA-06512: 在 "SYS.DBMS_REFRESH", line 195
ORA-06512: 在 line 1
ORA-12012: 自动执行作业 34 出错

Cause:
$ oerr ora 12011
12011, 00000, "execution of %s jobs failed"
// *Cause:  An error was caught in dbms_ijob.run from one or more jobs
//          which were due to be run.
// *Action: Look at the alert log for details on which jobs failed and why.
$ oerr ora 23404
23404, 00000, "refresh group \"%s\".\"%s\" does not exist"
// *Cause: A refresh group name was given that is not in sys.rgroup$.
// *Action: Provide a refresh group name that is in sys.rgroup$ or dbs_rgroup.
//

Solution:
问题上面应该很明确了，因为job what里使用的dbms_refresh，而刷新的视图不在sys.rgroup$里。
1，依然使用dbms_refresh刷新，需手工创建refresh group如下:然后再运行.
dbms_refresh.make(name,list,next_date,interval);
See this link for further information:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14227/rarrefreshpac.htm#i94057

2，直接使用dbms_mview.refresh来刷新物化视图.

注:
建议物化视图刷新还是优先使用dbms_mview包.