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 |
How do I find my oracle client driver version?
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.
how to get the no employee in each department including the dept which has 0 employee
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
Explain the use of rows option in imp command.
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.
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
How to run create database statement again?
What is materialized view in Oracle?
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?
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