Can We Restore a Table that accidantly dropped.
Answer Posted / attitude girl
Ofcourse Its Possible in New ORACLE 10g EDITION
you have to use flashback command for this.
Syntax:
FLASHBACK TABLE YOURTABLENAME TO BEFORE DROP;
LIKE
FLASHBACK TABLE EMP TO BEFORE DROP;
FLASHBACK COMPLETE.
YOU'LL BE AMAZED BY THIS.
THE BEST THIG IS THAT IT'LL EVEN GET YOUR DATA BACK AS WELL.
TRY THIS COMMAND.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What do you mean by hz_ in customer tables? : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
How to clone the database using RMAN back
What is auto invoicing? Explain : oracle accounts receivable
8. Supporting AP, AR and GL?
Explain the process of recievables in oracle financials. : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
What is the importance of batch source set up in ar? : oracle accounts receivable
How would you determine who has added a row to a table?
as a technical developer in oracle applications which type errors feced in your experience sofar
What view would you use to determine free space in a tablespace?
What is mrc and what is its use? : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable