A problem with sorting

From: <uday.v.lad_at_att.com>
Date: 1997/04/15
Message-ID: <01bc49b8$7d696300$48362c87@sap06.bsi.att.com>#1/1

Hi !
  I found some strange problem with ORACLE SORTING MECHANISM. The Situation is something like this :
  My table is sorted perfectly , please don't doubt on that issue and after loading
  no DML activities has been done on that table.   When i tried to create an index on the table on the sorted column , with NOSORT
option , it came out with following message after few minutes of working :

ORA-01409 NOSORT option may not be used ; rows are not not in acending order.

although, i know that the records are perfectly sorted . and i tried with small table
(37000 records) and it worked fine . this one is a huge table and having
around
4000000 records.

No Nulls in the sort key.

Can any body help on this issue ?

Please reply ASAP.

UDAY LAD
AT & T
(uday.v.lad_at_att.com)
Received on Tue Apr 15 1997 - 00:00:00 CDT