Accidentally i deleted my table. How can i get that table?
Answer Posted / 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 |
Post New Answer View All Answers
What is reportserver and reportservertempdb ?
Write a query to find 5th highest amount paid from the customer table.
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How to delete duplicate rows?
How can you hide the sql server instances?
What are temporal tables in sql server 2016?
Why use update_statistics command in sql server?
How can I create a new template for import ? : sql server management studio
What happens if strings are casted into wrong code pages in ms sql server?
What are the lambda triggers?
What is primary key and example?
What are different types of table joins?
what types of replication are supported in sql server? : Sql server database administration
Can you explain about buffer cash and log cache in sql server?
How many types of attribute relationships are there? : sql server analysis services, ssas