Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01409: NOSORT option may not be used; rows are not in
ascending order
- 1 Answers
- 3130 Views
- I also Faced
- E-Mail Answers
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-10616: Operation not allowed on this tablespace
ORA-21300: objects option not installed
ORA-12497: maximum combined categories exceeds string
CLSR-00523: Resource string is not enabled
ORA-09795: szrbuild: malloc of role structure failed.
ORA-01039: insufficient privileges on underlying objects of the view
ORA-38470: cannot revoke a privilege that was not granted.
PCC-01401: Your Pro*Pascal authorization is about to expire
PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE
ORA-16565: duplicate property, syntax error at "string"
ORA-01160: file is not a string
NID-00141: No database name specified, previous attempt used string
Oracle Errors 
