create table th_obj  PARTITION BY LIST(object_type) 
(partition p_tab values('TABLE'), 
partition p_def values(default)) 
as  
select * from user_objects where ROWNUM<=100

create index th_idx on th_obj (last_ddl_time)  local partition by hash(last_ddl_time) partitions 16 

create index th_idx on th_obj (last_ddl_time)  global partition by hash(last_ddl_time) partitions 16