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
How to call a sub procedure?
What do you mean by a deadlock?
How do I limit the number of oracle database connections generated by weblogic server?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is transaction control statement and how many types of transaction control statement in Oracle?
Can we save images in a database and if yes, how?
Whats the benefit of dbms_stats over analyze?
How can we find out the duplicate values in an oracle table?
What is the oracle implicit cursor?
Explain what are the characteristics of data files?
What are the uses of synonyms?
Explain what does a control file contain?
What is bulk copy or bcp in oracle?
What are the ansi data types supported in oracle?
Can select statements be used on views in oracle?