4 Replies Latest reply: Dec 1, 2008 11:56 PM by jayadevan RSS

    Change data capture - ignore delete?

    326156
      Hello,

      I'm trying to solve an issue I met on a synchronous change data capture : I created a CDC table with the DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE procedure:
      BEGIN
         DBMS_LOGMNR_CDC_PUBLISH.CREATE_CHANGE_TABLE (
            OWNER             => 'APPO',
            CHANGE_TABLE_NAME => 'CT_TEMP_H1',
            CHANGE_SET_NAME   => 'SYNC_SET',
            SOURCE_SCHEMA     => 'APPO',
            SOURCE_TABLE      => 'TEMP_H1',
            COLUMN_TYPE_LIST  => 'ISSUE VARCHAR2(10), TITOLO VARCHAR2(150)',
            CAPTURE_VALUES    => 'BOTH',
            RS_ID             => 'Y',
            ROW_ID            => 'N',
            USER_ID           => 'N',
            TIMESTAMP         => 'N',
            OBJECT_ID         => 'N',
            SOURCE_COLMAP     => 'Y',
            TARGET_COLMAP     => 'Y',
            OPTIONS_STRING    => NULL)
         ;
      END;
       
      Now, it works correctly, and in the CT_TEMP_H1 table I can find all the information about changes that occourr in the TEMP_H1 table

      What I'd like to know is if there is a way to avoid the capture "trigger" to fire in the event of DELETE records: due to the application business logic, I'm interested just in insert and updates on the source table, and I don't mind about delete(s), so I don't want them to consume resources (both disk space and CPU) on the server.
      Is there a supported way to do so?

      Thanks in advance,

      - Paolo