Accidentally i deleted my table. How can i get that table?
Answers were Sorted based on User's Feedback
Answer / ravi kanth
In 10g i think using flashback command we can get back.
Is This Answer Correct ? | 4 Yes | 2 No |
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 |
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 |
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What do you mean by tablesample?
What are triggers? How do you invoke a trigger on demand?
What is the definition for sql server 2000?
How to insert data into an existing table?
what is package and it uses and how can u call a package
Why Do you want to work in this company?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
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?
What is relationship? What number of sorts of relationship are there?
How to change the system date and time from SQL Plus Terminal ?
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
4 Answers CarrizalSoft Technologies, L&T,