ORA-01409: NOSORT option may not be used; rows are not in
ascending order
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-32761: Turn off Temp LOB Ref Count Feature
NNL-00342: Log file name is currently string
ORA-01251: Unknown File Header Version read for file number string
ORA-22059: buffer size [string] is too small - [string] is needed
PCC-02445: USING clause valid only on a PREPAREd dynamic statement
LSX-00251: invalid token "~S"
ORA-17620: failed to register the network adapter with Oracle Disk Manager library: string
ORA-39059: dump file set is incomplete
ORA-10564: tablespace string
ORA-25133: duplicate SINGLE TABLE option specified
ORA-19762: invalid file type string
NZE-28872: Invalid peer certificate format