Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I check the date on which the partition was created

moonfeelJun 16 2013 — edited Jun 16 2013

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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2013
Added on Jun 16 2013
1 comment
7,366 views