Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between all_indexes and user_indexes

239564Mar 18 2004 — edited Mar 21 2004

Dear all,

I assume that all_indexes should included all records from user_indexes. Am I right ?

Below are the data from my 10g, why the LOB index type does not appear in all_indexes ?

SQL> select distinct index_type from all_indexes;

INDEX_TYPE
---------------------------
DOMAIN
FUNCTION-BASED DOMAIN
FUNCTION-BASED NORMAL
IOT - TOP
NORMAL

SQL> c/all_/user_
1* select distinct index_type from user_indexes
SQL> /

INDEX_TYPE
---------------------------
FUNCTION-BASED NORMAL
LOB
NORMAL

SQL>

Thanks a lot,
Kelvin

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2004

Added on Mar 18 2004

#general-database-discussions

4 comments

939 views