i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
Answer Posted / asnani_satish@yahoo.com
Flashback table feature is available from Oracle 9i onwards
only. Before that deleted records once committed cannot be
rolled back. As far as Oracle 9i onwards the solution
specified by Bipin Maurya is correct. But i would like to
add something. For using FLASHBACK TABLE the user must be
granted privilege for the same. But there is another way out.
create table temp_new as select * from temp as of timestamp
to_timestamp('11/01/2011 08:45:00','dd/mm/yyyy hh24:mi:ss');
This will bring the table to the point in time specified by
timestamp.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are advantages of dateset in datastage?
How to increment dates by 1 in oracle?
How to rename an index in oracle?
How will you differentiate between varchar & varchar2?
Difference between open_form and call_form in oracle.
What is the difference between substr and instr?
What are the oracle differences between nvl and coalesce
How to write numeric literals in oracle?
Explain table?
Calculate difference between 2 date / times in oracle sql?
What are the data types in oracle?
Can group functions be used in the order by clause in oracle?
What is a procedure in oracle?
What are oracle functions?
How to rename an index?