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 are indexers?
Name few of the dcl commands in sql?
What is exporting and importing utility?
Write a sql query to get zero records from a table having n number of records?
what is a schema in sql server 2005? : Sql server database administration
explain extended properties
What is transaction server consistency?
How many types of schemas are there?
What do you mean by sql server 2005 express management tools?
Tell me about joins in database system and explain each in detail.
Do you know what is similarity and difference between truncate and delete in sql?
What are views used for?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is collation?
What command would you use to add a column to a table in sql server?