ORA-26808: Apply process AS0I died unexpectedly. ORA-01688: unable to extend table SYS.STREAMS$_APPL

ORACLE STREAM 应用进程意外终止，错误原因：
ORA-26808: Apply process AS0I died unexpectedly.
ORA-01688: unable to extend table SYS.STREAMS$_APPLY_SPILL_MSGS_PART partition P2 by 1024 in tablespace SYSAUX




1、下载文件：streams_purge_apply_spill_txn.plb
2、在目标端sys用户下执行streams_purge_apply_spill_txn.plb文件，文件执行成功后将会在sys用户下创建一个存储过程 purge_spill_txn
connect / as sysdba 
@streams_purge_apply_spill_txn.plb
3、使用以下语句查询有溢出消息的应用进程，如AP_14
select apply_name, xidusn||'.'||xidslt||'.'||xidsqn txn_id, first_scn, first_message_create_time, message_count, spill_creation_time from dba_apply_SPILL_TXN;
4、将有溢出消息的应用进程停止
begin
dbms_apply_adm.stop_apply('AP_14');
end;
/


5、删除溢出的消息


BEGIN
 FOR V_TXID IN (SELECT A.XIDUSN || '.' || A.XIDSLT || '.' || A.XIDSQN AS TXID
                  FROM DBA_APPLY_SPILL_TXN A) LOOP
   SYS.PURGE_SPILL_TXN('AP_14', V_TXID.TXID);
 END LOOP;
END;
/


6、清空表truncate table SYS.STREAMS$_APPLY_SPILL_MSGS_PART;


7、启动应用进程
begin
dbms_apply_adm.start_apply('AP_14');
end;