Database Administration (MOSC)

MOSC Banner

Check for index existing.

edited Oct 4, 2012 10:07AM in Database Administration (MOSC) 7 commentsAnswered ✓
I'm a DBA working with 3 application developers, they want to know how to check for index existing for certain column 
in a table in their schema,

one friend told me , to check for index existing for certain column you have to query
the view dba_ind_columns so you have to be a sysdba user

but I don't want to grant the application developers the sysdba privilage

but my friend told me , to avoid grant sysdba to the application developers, they can query the view user_indexes in their schema, but after watching the view user_indexes ,

it gives me a lot of data but doesn't give me the COLUMN NAME 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center