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
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
What do you mean by hz_ in customer tables? : oracle accounts receivable
Are These Dff's Flexible?
What is the disk migration? what is the steps involved in oracle disk migration?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
HOW TO SPOT AHIERARCHY?
What is the mandatory setup in cyclecount ?
How to clone the database using RMAN back
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is Tax Categories?