how to get the index id?
- 1 Answers
- 5207 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer / 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 |
Can a primary key contain more than one columns?
What is the function of Optimizer ?
what is the dual table in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What does ROLLBACK do ?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain the importance of .pll extension in oracle?
How to drop an index in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to define a data source name (dsn) in odbc manager?
How to experiment a data lock in oracle?
What is Parallel Server ?
Oracle General 
