SELECT SRC.table_name, 
       SRC.partition_name  SRC_PARTITION, 
       DEST.partition_name DEST_PARTITION 
FROM   (SELECT table_name, 
               partition_name 
        FROM   (SELECT PC.table_name, 
                       Max(PC.last_analyzed)                    LAST_ANALYZED, 
                       PC.partition_name, 
                       Row_number() 
                         over ( 
                           PARTITION BY PC.table_name 
                           ORDER BY Max(PC.last_analyzed) DESC) R 
                FROM   user_ind_columns IC 
                       join user_indexes I 
                         ON IC.index_name = I.index_name 
                       join user_part_col_statistics PC 
                         ON IC.table_name = PC.table_name 
                            AND PC.column_name IN ( IC.column_name, 'SAMPLETIME' 
                                                    , 
                                                    'DOWNTIME_STATE' ) 
                WHERE  I.index_type = 'BITMAP' 
                GROUP  BY PC.table_name, 
                          PC.partition_name 
                HAVING SUM(Decode(PC.histogram, 'NONE', 1, 
                                                0)) = 0) 
        WHERE  r = 1) SRC 
       join user_tab_partitions DEST 
         ON SRC.table_name = DEST.table_name 
            AND DEST.sample_size IS NULL 
            AND EXISTS (SELECT 1 
                        FROM   user_indexes DI 
                        WHERE  DI.table_name = DEST.table_name 
                               AND DI.index_type = 'BITMAP') 
ORDER  BY SRC.table_name, 
          DEST.partition_name;