As subject, how can I know the date on which the partition was created.
I do have the query below, from the query, I may know when the partition was last analyzed, but, I have no idea when it was created.
select s.table_name,
s.partition_name,
s.high_value,
s.num_rows,
s.last_analyzed
from user_tab_partitions s
where s.table_name = 'UBE_UNIT_DATA_EXT'
order by 5 asc;
Anyone help please?