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

How do I find my oracle client driver version?

0 Answers  


5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,


how to get the no employee in each department including the dept which has 0 employee

5 Answers  


Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,


Explain the use of rows option in imp command.

0 Answers  






write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,


How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,


How to run create database statement again?

0 Answers  


What is materialized view in Oracle?

0 Answers   MCN Solutions,


How many different types of indexes we have in oracle?

24 Answers   IBM, TCS,


what is the difference between first normal form & second normal form?

11 Answers   IBM, Oracle,


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers   iFlex,


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)