3,490
社区成员
发帖
与我相关
我的任务
分享
Errors in file /opt/oracle/admin/ljdxts/bdump/ljdxts_q004_8859.trc:
ORA-04063: U_DL_STREAM.SOURCE_QUEUE has errors
Fri Oct 22 16:37:04 2010
Errors in file /opt/oracle/admin/ljdxts/bdump/ljdxts_q003_8861.trc:
ORA-04063: U_DL_STREAM.SOURCE_QUEUE has errors
Fri Oct 22 16:37:09 2010
Errors in file /opt/oracle/admin/ljdxts/bdump/ljdxts_q004_8863.trc:
ORA-04063: U_DL_STREAM.SOURCE_QUEUE has errors
........
*** SERVICE NAME:(SYS$BACKGROUND) 2010-10-22 16:38:35.468
*** SESSION ID:(137.495) 2010-10-22 16:38:35.468
KSV 4063 error in slave process
*** 2010-10-22 16:38:35.468
ORA-04063: U_DL_STREAM.SOURCE_QUEUE has errors
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-04063: U_DL_STREAM.SOURCE_QUEUE has errors
--创建queue语法
begin
dbms_streams_adm.set_up_queue(
queue_table=>'source_queue_table',
queue_name =>'source_queue'
);
end;
/
--删除queue语法
--首先stop queue, 报错:
SQL> exec dbms_aqadm.stop_queue('source_queue');
BEGIN dbms_aqadm.stop_queue('source_queue'); END;
*
ERROR at line 1:
ORA-04063: U_DL_STREAM.SOURCE_QUEUE has errors
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4913
ORA-06512: at "SYS.DBMS_AQADM", line 240
ORA-06512: at line 1