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
steff007 (AT) umn (DOT) edu

On Apr 14, 12:03*pm, steff007... (AT) gmail (DOT) com wrote:
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

steff007jim (AT) gmail (DOT) com 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.

USER_xxx views will show you the things that your username owns, which are
typically the objects your username creates.

If an account called SYSADM was used to create an object then most likely
that account now owns the object, and the object will appear in a USER_xxx
view only if you login as SYSADM.

You should find the objects in the appropriate ALL_xxx view, assuming you
have what ever permissions are needed to do that.