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 |
what is the use of rank function?
What is hash cluster in oracle?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is tns entry?
What is an oracle data file?
how to hide the stored procedure inside a package
6. Display the client name and order date for all orders using the traditional method.
What is a subquery in oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
How to write a query with an inner join in oracle?