how to get the index id?

Answer Posted / su

we can use USER_INDEXES or DBA_INDEXES
sql> desc user_indexes
index_name
index_type
table_owner
table_name
table_type
and plenty of other columns

sql>SELECT index_name
FROM user_indexes
WHERE table_name = 'EMP';
will give us the index_name, which is how we identify an
index

:) hope this helps

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give the various exception types.

764


What is the usage of control file in oracle?

849


Explain an index?

904


Explain the use of rows option in imp command.

812


How to define an anonymous block?

847


How data locks are respected in oracle?

839


How to create a single index for multiple columns?

787


How much memory your 10g xe server is using?

842


How can we find out the duplicate values in an oracle table?

845


What is sequence?

850


How to get execution statistics reports on query statements?

838


How many types of segments in Oracle?

820


Differentiate between translate and replace?

837


What is ordinary table in oracle?

854


What is primefaces used for?

820