11 Replies Latest reply on Mar 20, 2017 4:52 PM by rp0428

    How to get last modified/inserted partition ?

    sinan_gg

      Hi All,

       

      I m trying to analyze latest dml processed partitions for each table.  Is there anyone know how to get latest inserted/deleted partition name in tables. I didnt find any "last_modified" column in all_tab_partitions table.

       

      Any idea of this problem ?

       

      Thanks,

      Sinan