The N/A indicates the index is partitioned and you need to get the
status at the partition level from ?_ind_partitions vs ?_indexes
- Brian
- Cherie_Machler_at_gelco.com wrote:
> List,
>
> One of our developers has a question about the possible values of the
> STATUS
> column in the
> ALL_INDEXES view. He has queried the view for an index he is
> interested in.
> The index he
> is interested in has a status of N/A (while other indexes he is
> interested in
> have a status of valid).
>
> What does a status of N/A signify. I looked in the Server Reference
> Manual but
> there's not any
> detail about possible values and what they mean. Is there another
> resource we
> can look at to
> tell us what the possible values mean?
>
> Thanks in advance,
>
> Cherie
>
>
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
Received on Wed Aug 09 2000 - 06:06:55 CDT