How Do I Delete XStream Outbound Created When XStream Is Enabled?

Procedure

1. Run the following SQL statements on the source database to check whether XStream Outbound created by the DRS task exists:

   SELECT SERVER_NAME, 
          CONNECT_USER, 
          CAPTURE_USER,
          CAPTURE_NAME,
          SOURCE_DATABASE,
          QUEUE_OWNER,
          QUEUE_NAME
   FROM DBA_XSTREAM_OUTBOUND;

   The naming format of SERVER_NAME of XStream Outbound is DRS_+Task ID in uppercase. The hyphen in the uppercase task ID will be replaced by an underscore (_), for example, DRS_04981F62_84A4_4974_A5D5_772ED2DF63AC.

2. If XStream Outbound exists, run the following SQL statement to delete it: In the following statement, <xstream SERVER_NAME> indicates the value of SERVER_NAME obtained in 1.

   BEGIN DBMS_XSTREAM_ADM.DROP_OUTBOUND(server_name => '<xstream SERVER_NAME>');END;