how to get the index id?
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 |
What happens to indexes if you drop a table?
primary key is foreign key for the same table?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is oracle join syntax?
what is the syntax of DROP command?
How to define an external table with a text file?
What is a SNAPSHOT ?
How to view existing locks on the database?
What are named parameters?
What is a Private Synonyms ?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?