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

How to create a temporary table in oracle?

694


Can we convert a date to char in oracle and if so, what would be the syntax?

550


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1860


How data locks are respected in oracle?

574


How do I know if oracle client is installed on windows?

498






Why use resource manager in Oracle?

665


what is the difference between functional dependecy and multilevel dependency?

1994


What do you mean by a tablespace?

566


How to synchronize 2 schema's objects?

1690


How to initialize variables with default values?

636


How to display row numbers with the records?

588


How to get execution path reports on query statements?

566


how may join possible between (requisition with purchase order)

1699


Is postgres faster than oracle?

561


How do I know if oracle is installed on windows?

488