How to recover a dropped index?



How to recover a dropped index?..

Answer / rajmohan

The index would come back but the name doesn't get changed and keeps the system name.
You can see that the index is there but didn't recover its original name.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

Youre getting high busy buffer waits - how can you find whats causing it?

1 Answers  


What does COMMIT do ?

4 Answers  


can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,


List the various oracle database objects?

0 Answers  


how to find count rows in table without count function?

3 Answers   Oracle,






What is the disadvantage of User defind function?

0 Answers   CybAge,


What is a database table in oracle?

0 Answers  


when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  


Why is oracle database so popular?

0 Answers  


What is an oracle user account?

0 Answers  


What happens to the current transaction if the session is ended?

0 Answers  


T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)