Interested to Buy Any Domain ? << Click Here >> for more details...
i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
- 7 Answers
- 12943 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 is meant by raw datatype?
What is a snapshot log?
What is concurrency in oracle?
what is IDE,DMV in sql server?
How to insert multiple rows with one insert statement in oracle?
How are extents allocated to a segment?
How to define an anonymous block?
What is difference between sid and service name in oracle?
What are the common oracle dba tasks?
Where is the export dump file located?
How to call a sub procedure?
What is the difference between sharding and partitioning?
What is a view and how is it different from a table?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to change user password in oracle?
