Oracle中user_tab_partitions的高值排序

Question

我试图在PL/SQL块中运行下面的查询

SELECT partition_name, high_value FROM user_tab_partitions WHERE table_name = 'BRD_JOB_DETAILS_TMP' order by high_value;

我收到错误消息：ORA-00997: illegal use of LONG datatype

我需要按照high_value的顺序处理表分区，以消除以下问题：

ORA-14074: partition bound must collate higher than that of the last partition

Answer 1

使用数字列partition_position代替您的订单。

SELECT partition_name, high_value FROM user_tab_partitions WHERE table_name = 'BRD_JOB_DETAILS_TMP' order by partition_position;