How to recover a dropped index?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1455


Compare and contrast between sql and sql server and explain its various functions?

549


what are steps for interface? where is exchange rate defined in which table?

1508


What do you know about normalization? Explain in detail?

506


What is the difference between 10g OEM and 11g OEM?

569






21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1627


How to specify default values in insert statement using oracle?

574


Does oracle database need java?

535


How to synchronize 2 schema's objects?

1701


What is parameterized cursor in oracle?

589


What is logical backup in oracle?

582


What are the arithmetic operations?

597


What is a tns service name?

548


How to sort output in descending order in oracle?

586


How many data types are supported?

626