DBA_TAB_PARTITIONS
Date: Tue, 16 Jan 2018 19:46:07 +0000
Message-ID: <258575162B63424EB58DAE3A5475B6ED012CD0646B_at_EXNJMB25.nam.nsroot.net>
We are trying to create a sql which will create a script of partitions to compress which are older than a certain date. That information is kept in High_value. When displayed high_value looks like this
TO_DATE(' 2017-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')
So the first thing we did was to query where high_value like 'TO_DATE%'. We got an invalid character error. Long story short, we discovered that high_value's data type is long. There must be a way to translate this into text. SQLplus, Sqldeveloper, and TOAD all do that. The question is how do they do it? Does anyone know how it is done?
Thanks,
Liz
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 16 2018 - 20:46:07 CET