If the index is a unique index, then ORA-1502 is not suppressed. If not, it surely looks like a bug. File an iTAR, and let us know how OWS addresses it.
- Kirti --- Sai Selvaganesan <[EMAIL PROTECTED]> wrote: > hi > i am trying to figure out how unusable indexes could > help me in certain cases like bulk loading etc. i am > trying to understand how it works. > > i created a table with a index and used a query which > used this index. > > later i made this index unusable and unless and until > i make this index non-existent the query always > returns a 1502 error trying to access the table thru > the unusable index when i can see that full table scan > is still an option. the init.ora parameter > skip_unusable..is set up too. > > version is 9.2.0.3 on aix 5l. > > can someone clarify whether this is how it is supposed > to work or am i missing something . > > thanks > sai > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
