i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
- 7 Answers
- 10780 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / serena
Using flashback table:
# enable row movement
1) alter table test2 enable row movement;
# flashback test2 to 10 minutes ago.
2) FLASHBACK TABLE test2 TO TIMESTAMP SYSTIMESTAMP -
INTERVAL '10' MINUTE;
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
what are bitmap indexes? How does they work?
Why do you use stored procedures and state some of its disadvantages?
Explain the use of indexes option in imp command.
Which is better Oracle or MS SQL? Why?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
 How to use an oracle sequence generator in a mapping?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How view is different from a table?
How to sort the query output in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
List out the difference between commit, rollback, and savepoint?
What are the set operators union, union all, minus & intersect meant to do?
How do we get field details of a table?
Why we use bulk collect in oracle?
What is difference between truncate and delete?
