Skip to Main Content
Forums

Database Software

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 to convert high_value to date data type on dba_tab_partitions

Siva OraFeb 22 2012 — edited Mar 23 2012
I just want to query and get the max date available on the dba_tab_partitions for the high_value field.

high_value data type is LONG it has the value for Partition bound value expression.

For example on my partition table the expression is like TO_DATE(' 2012-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')

I just want to convert the high_value to date data type.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2012
Added on Feb 22 2012
#advanced-compression, #data-warehousing
1 comment
14,687 views