Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UNUSABLE INDEXES

Re: UNUSABLE INDEXES

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 21 Apr 1999 14:20:51 -0700
Message-ID: <371E4133.7EF2C356@us.oracle.com>


Michael

Check the STATUS column of DBA/ALL/USER_INDEXES.

HTH. Pete

larionov_at_yahoo.com wrote:

> Hi
>
> Could you please tell me how can I get a list of all unusable indexes.
> I am using Oracle8.0.
>
> Thank you very much!
>
> Michael.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--

Regards

Pete


Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)
San Francisco

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA



Received on Wed Apr 21 1999 - 16:20:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US