ORA-24036: invalid SORT_ORDER column string specified for queue table

ORA-24036: invalid SORT_ORDER column string specified for queue table
Cause: The create queue table command was issued with message_grouping set to TRANSACTIONAL and a sort order column other than priority. Only the priority column can be specified in the sort order for queue tables with transactional grouping.
Action: Change the sort order list in the create queue table command and retry the call.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-24036：为队列表指定的无效SORT_ORDER列字符串,
.原因：发出create queue table命令，并将message_grouping设置为TRANSACTIONAL，并且排除了优先级以外的排序顺序列。只能为具有事务分组的队列表的排序顺序指定优先级列。,
.操作：更改create queue table命令中的排序顺序列表，然后重试调用。,
.

aiaiDBA

13718043309

010-86462881

ORA-24036: invalid SORT_ORDER column string specified for queue table

1 个回答

相似问题