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 |
Why we need sql server?
What is the difference between left and right outer join?
How do I make a resultset scrollable?
what is dbcc? : Sql server database administration
Is truncate autocommit?
How to write query to Delete the records in child table and corresponding records in parent table
Can one drop a column from a table?
How is sql server used?
Plz tell about backup&recovery?
ehat is the default port no of sql 2000?
What is b tree index?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication