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

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

More SQL Server Interview Questions

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  


What do you mean by tablesample?

0 Answers  


What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,


What is the definition for sql server 2000?

0 Answers  


How to insert data into an existing table?

0 Answers  






what is package and it uses and how can u call a package

0 Answers   Satyam,


Why Do you want to work in this company?

4 Answers   HCL,


What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  


1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,


What is relationship? What number of sorts of relationship are there?

0 Answers  


How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,


WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,


Categories