DBA Data[Home] [Help]

VIEW: SYS._DBA_APPLY

Source

View Text - Preformatted

select
  apply#, apply_name, queue_oid, queue_owner, queue_name, status, flags,
  ruleset_owner, ruleset_name, message_handler, ddl_handler, precommit_handler,
  apply_userid, apply_dblink, apply_tag, start_date, end_date,
  negative_ruleset_owner, negative_ruleset_name, spare1, spare2, spare3,
  status_change_time, error_number, error_message, ua_notification_handler,
  ua_ruleset_owner, ua_ruleset_name
from sys.streams$_apply_process
View Text - HTML Formatted

SELECT APPLY#
, APPLY_NAME
, QUEUE_OID
, QUEUE_OWNER
, QUEUE_NAME
, STATUS
, FLAGS
, RULESET_OWNER
, RULESET_NAME
, MESSAGE_HANDLER
, DDL_HANDLER
, PRECOMMIT_HANDLER
, APPLY_USERID
, APPLY_DBLINK
, APPLY_TAG
, START_DATE
, END_DATE
, NEGATIVE_RULESET_OWNER
, NEGATIVE_RULESET_NAME
, SPARE1
, SPARE2
, SPARE3
, STATUS_CHANGE_TIME
, ERROR_NUMBER
, ERROR_MESSAGE
, UA_NOTIFICATION_HANDLER
, UA_RULESET_OWNER
, UA_RULESET_NAME FROM SYS.STREAMS$_APPLY_PROCESS