我正在嘗試在我的 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
uj5u.com熱心網友回復：
使用數字列partition_position代替您的訂單。
SELECT partition_name, high_value FROM user_tab_partitions WHERE table_name = 'BRD_JOB_DETAILS_TMP' order by partition_position;
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/346146.html