Hello,
After I create a logical partition tracking object by following the steps detailed here, I cannot find everything I need in the data dictionary to recreate it.
SYS.KU$_LOGPART_VIEW has almost everything I need, but not high bounds. The BHIBOUNDVAL column is unreadable (is there some way to convert this to VARCHAR2?). And the HIBOUNDVALC column is always null. So I can't determine the “VALUES LESS THAN” clauses in the command below…
CREATE LOGICAL PARTITION TRACKING ON mysales
PARTITION BY RANGE (time_id)
INTERVAL(NUMTOYMINTERVAL(2, 'YEAR'))
(
PARTITION p0 VALUES LESS THAN (TO_DATE('7-15-2005', 'MM-DD-YYYY')),
PARTITION p1 VALUES LESS THAN (TO_DATE('7-15-2007', 'MM-DD-YYYY'))
);
The SYS.TABLOGICPART$ table has these values, but most users won't have the READ privilege on this table, so it doesn't do a lot of good.
Also, there isn't any USER/ALL/DBA_LOGICAL_PARTITIONS (or similar) which seems like a miss. I see USER_MVIEW_DETAIL_LOGICAL_PARTITION, but this doesn't contain any rows until a MVIEW that uses the partition tracking objects is created.
Thanks
John Dorlon