Re: View Indexes

From: ddf <>
Date: Tue, 14 Apr 2009 11:52:30 -0700 (PDT)
Message-ID: <>

On Apr 14, 12:03 pm, wrote:
> I'm trying to view all the indexes in an Oracle table. I try the
> command "select * from USER_INDEXES" and I get no results. I no there
> area tons of tables and indexes in this database (which by the way was
> created by SYSADM. How can I view them.
> Thanks,
> Jim Steffes

That depends. Your non-DBA account probably does not have access to every table in the database, thus it can't 'see' every associated index. You can use the ALL_INDEXES view, which reports the indexes on tables you can access (which includes tables your account does not own but that your account has been granted privileges on). To really see everything you need to have a DBA-privileged account so you can query the DBA_INDEXES view, which does show every index in the database, regardless of who owns it. Of course you'll want more information than any of the %_INDEXES views provides which leads you to the ALL_IND_COLUMNS view and, if you're lucky enough to have DBA privileges, the DBA_IND_COLUMNS view.

David Fitzjarrell Received on Tue Apr 14 2009 - 13:52:30 CDT

Original text of this message