3 Replies Latest reply: Nov 4, 2013 1:54 AM by 1000662 RSS

    I've got an Event_alert " Failed to validate table OGG.DBMS_TABCOMP_TEMP_CMP."

    1000662

      version info:  ggs 11.2.1.0.11

                          oracle11.0.2.3.7

                          after a few minites the issue was recover automatically .

      variable info:

      -- Identify the data pump group:

      EXTRACT pum_1

      USERID ogg, PASSWORD ogg

       

      SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

       

       

      ------------------

      --RMTHOST <system_2>, MGRPORT <portnumber>, ENCRYPT <encryption options>

      RMTHOST 10.41.214.17, MGRPORT 7809

       

      --ENCRYPTTRAIL <encryption options>

      RMTTRAIL ./dirdat/r1

       

      PASSTHRU

       

      OBEY ./dirprm/pum_.txt

      -------------------

      EXTRACT IS

      USERID ogg, PASSWORD ogg

      TRANLOGOPTIONS EXCLUDEUSER ogg

       

       

      SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

       

      DDL INCLUDE ALL, EXCLUDE OBJNAME SCOTT.*

       

      DDLOPTIONS ADDTRANDATA

       

      DYNAMICRESOLUTION 

       

       

      OBEY ./dirprm/ext_.txt

       

      ------------------------------------------------------------------------------------------------------------------------------------------------ 

       

      Event_alert

       

      New Events for paydb_xl

      Process: ext_1

      Time: 2013-10-09 22:00:08

      Event Text: Oracle GoldenGate Capture for Oracle, ext_1.prm: Failed to validate table OGG.DBMS_TABCOMP_TEMP_CMP. The table is compressed and extract will not be able to extract data from Oracle logs.

       

      Process: ext_1

      Time: 2013-10-09 22:00:08

      Event Text: Oracle GoldenGate Capture for Oracle, ext_1.prm: PROCESS ABENDING.