Can We Restore a Table that accidantly dropped.
- 8 Answers
- 13140 Views
- TCS, I also Faced
- E-Mail Answers
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
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What is auto invoicing? : oracle accounts receivable
3. Steps in UAT?
1. What is PO rate variance gain and loss?
What do you mean by hz_ in customer tables? : oracle accounts receivable
8. Supporting AP, AR and GL?
what is difference between inner join & nested query or subqueries
What is Tax Categories?
what are the API of GL,PO,AP
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Explain the use of table functions.
How would you determine who has added a row to a table?
