aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-01409: NOSORT option may not be used; rows are not in ascending order

ORA-01409: NOSORT option may not be used; rows are not in ascending order
Cause: Creation of index with NOSORT option when rows were not ascending. For non-unique indexes the rowid is considered part of the index key. Therefore, if you create an index nosort and two of the rows in the table have the same key and are stored in ascending order, but get split accross two extents where the dba of the first block in the second extent is less than the dba of the last block in the first extent, then the create index nosort may fail.
Action: Create the index without the NOSORT option, or ensure table is stored in one extent.

请先 登录 后评论

1 个回答

小智
ORA-01409:可以不使用NOSORT选项; 行不按升序排列,
.原因:当行不升序时,使用NOSORT选项创建索引。对于非唯一索引,rowid被认为是索引键的一部分。因此,如果创建索引节点,并且表中的两个行具有相同的键,并以升序存储,但获得跨两个扩展区的分割,其中第二个扩展区中的第一个块的dba小于dba最后一个块在第一个extent,那么create index nosort可能会失败。,
.操作:创建没有NOSORT选项的索引,或确保表存储在一个extent中。,
.
请先 登录 后评论