Accidentally i deleted my table. How can i get that table?

Question Posted / siva

4 Answers
8360 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Accidentally i deleted my table. How can i get that table?..

Answer / ravi kanth

In 10g i think using flashback command we can get back.

Is This Answer Correct ?

4 Yes

2 No

Accidentally i deleted my table. How can i get that table?..

Answer / adhi

IN MS SQL SERVER 2005.

1.Take Tail Log backup
2.Restore Full backup
3.Restore Diff (If u have)or Log backup in sequence order
4.Restore Tail Log backup

Is This Answer Correct ?

1 Yes

1 No

Accidentally i deleted my table. How can i get that table?..

Answer / ravi

In this case data only deleted but table structure is there.
so can flashback the the data.
example:-

delete * from emp;

ans:- insert into emp select * from emp as of timestamp
sysdate -3/1440;

Is This Answer Correct ?

0 Yes

3 No

Accidentally i deleted my table. How can i get that table?..

Answer / anil panwar

tell me which command used for delete..

Is This Answer Correct ?

1 Yes

5 No

Post New Answer