1.

1. 
   delete from t1                                    
2.  where rowid in                                   
3.  ( select rid                                     
4.      from (                                       
5.    select rowid rid ,                             
6.           row_number() over                       
7.           (partition by  OWNER           ,        
8.                          OBJECT_NAME     ,        
9.                          SUBOBJECT_NAME  ,        
10.                          OBJECT_ID       ,        
11.                          DATA_OBJECT_ID  ,        
12.                          OBJECT_TYPE     ,        
13.                          CREATED         ,        
14.                          LAST_DDL_TIME   ,        
15.                          TIMESTAMP       ,        
16.                          STATUS          ,        
17.                          TEMPORARY       ,        
18.                          GENERATED       ,        
19.                          SECONDARY                
20.                          order by OBJECT_ID) rn   
21.      from t1                                      
22.               )                                   
23.     where rn <> 1                                 
24.  ) ; 

2.

1. delete from av a 
2.  where rowid not in 
3.        (select max(b.rowid) from av b where a.title = b.title);    

3.