Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the index id?
- 1 Answers
- 5710 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 |
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are ddl statements in oracle?
What are the types of trigger in oracle?
What is difference between SQL and SQL*PLUS?
What are the limitations oracle database 10g xe?
What is the difference between sharding and partitioning?
How to install oracle odbc drivers?
How to select an oracle system id (sid)?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Can a field be used in a report without it appearing in any data group ?
How to do clean up if create database failed?
what are the database links ?
Oracle General 
