>>>>>>>>>>>> Mamta Satoor wrote (2005-05-06 06:17:00): > Hi Brent, > > The warning is not for the index name. It is because the 2nd index is > getting defined on the same column as the first index.
Thanks. I should have thought of that. But the second index is not created. Shouldn't the warning have been an error (since two consecutive creations cannot be followed by two corresponding drops)? ij> create index x1 on tab1(i); 0 rows inserted/updated/deleted ij> create index x2 on tab1(i); 0 rows inserted/updated/deleted WARNING 01504: The new index is a duplicate of an existing index: X1. ij> drop index x2; ERROR 42X65: Index 'X2' does not exist. ij> drop index x1; 0 rows inserted/updated/deleted -- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Norway
