Stream Troubleshooting
# Is the Capture Process Enabled?
SELECT CAPTURE_NAME, STATUS_CHANGE_TIME, ERROR_NUMBER, ERROR_MESSAGE
FROM DBA_CAPTURE;
select capture_name,queue_name,status,captured_scn,applied_scn from dba_capture;
select apply_name,apply_captured,status,error_number,error_message from dba_apply;
ORA-26687
resolution:
page revision: 2, last edited: 24 Oct 2008 14:05