i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
- 7 Answers
- 10826 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / bipin maurya
first of all u can executed first query after that u can executed sec query
ALTER TABLE table2 ENABLE ROW movement
flashback TABLE table2 TO timestamp systimestamp-interval
'100' minute
Thanks
Bipin Maurya
Mo-+919812630225
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is dynamic proxy?
How to insert a record into a table?
how may join possible between (requisition with purchase order)
How do I learn what codesets are available in oracle?
Is java required for oracle client?
What is difference between cartesian join and cross join?
How to rebuild an index in oracle?
Can you create a synonym without having a table?
What do you mean by merge in oracle and how can you merge two tables?
How to assign a tablespace to a users in oracle?
What are the different types of failures that occur in Oracle database?
Why does Oracle not permit the use of PCTUSED with indexes?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to load a large xml file?
How a tablespace is related to data files?
