Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-26664: cannot create STREAMS process string

1 Answers  


NNL-00277: Maximum number of times a request can be reforwarded is currently number

1 Answers  


KUP-04043: table column not found in external source: string

1 Answers  


ORA-27151: buffer not large enough to hold process ID string

1 Answers  


SQL*Loader-00404: Column string present more than once in string's INTO TABLE block.

1 Answers  


ORA-19763: compatibility version string is higher than maximum allowed: string

1 Answers  


ORA-02027: multi-row UPDATE of LONG column is not supported

1 Answers  


ORA-14046: a partition may be split into exactly two new partitions

1 Answers  


ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.

1 Answers  


ORA-22606: pickler image handle [string] is not well-formed

1 Answers  


SQL*Loader-00526: OCI return status: success with info

1 Answers  


ORA-22306: type "string"."string" already exists

1 Answers  


Categories