Using flashback table: # enable row movement 1) alter table test2 enable

i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?

Question Posted / serena

7 Answers
12991 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

Please Help Members By Posting Answers For Below Questions

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2400

What is a procedure in oracle?

1202

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1739

What are the tools for Oracle ?

1069

When system tablespace is created?

1046

How do I reset a sequence in oracle?

1105

What is backup in Oracle?

1008

How to commit the current transaction in oracle?

1127

Explain do view contain data?

1016

Is rowid unique in oracle?

1002

Where is the export dump file located?

1163

What is translate in oracle?

1100

What is an oracle database table?

1017

What is the difference between count (*), count (expression), count (distinct expression)?

1013