1 Reply Latest reply on Nov 8, 2019 9:54 PM by Boček Petr

    Cache polling event - deleting rows from polling table

    Boček Petr

      Hi please can anybody explain to me? I have a polling table with these records for example

       

      CATALOG_NAMEDATABASE_NAMEOTHER_RESERVEDSCHEME_NAMETABLE_NAMEUPDATE_TSUPDATE_TYPE
      nullnullnullnullTABLE18.11.2019 7:50:51,1111111
      nullnullnullnullTABLE28.11.2019 7:50:51,2222221
      nullnullnullnullTABLE38.11.2019 7:50:51,1111111

       

      The event will add new records

       

      CATALOG_NAMEDATABASE_NAMEOTHER_RESERVEDSCHEME_NAMETABLE_NAMEUPDATE_TSUPDATE_TYPE
      nullnullnullnullTABLE18.11.2019 7:50:51,1111111
      nullnullnullnullTABLE28.11.2019 7:50:51,2222221
      nullnullnullnullTABLE38.11.2019 7:50:52,1111111
      nullnullobis1nullTABLE18.11.2019 7:50:511
      nullnullobis1nullTABLE28.11.2019 7:50:511
      nullnullobis1nullTABLE38.11.2019 7:50:521

       

      And then performs delete and result look like this:

       

      CATALOG_NAMEDATABASE_NAMEOTHER_RESERVEDSCHEME_NAMETABLE_NAMEUPDATE_TSUPDATE_TYPE
      nullnullnullnullTABLE18.11.2019 7:50:51,1111111
      nullnullnullnullTABLE28.11.2019 7:50:51,2222221
      nullnullnullnullTABLE38.11.2019 7:50:52,1111111
      nullnullobis1nullTABLE18.11.2019 7:50:511
      nullnullobis1nullTABLE28.11.2019 7:50:511

       

      It perfroms delete just to the datetime which is truncated to seconds and only the unique ones. So my question is how can I achieve that the records will be all deleted after cache purging? Oracle documentation says the UPDATE_TS is unique key, but this is though without the seconds decimals.