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 <ssaisundar_at_sbcglobal.net> 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: kirtikumar_deshpande_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Thu May 29 2003 - 23:56:03 CDT
