Interested to Buy Any Domain ? << Click Here >> for more details...
i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
- 7 Answers
- 13157 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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 convert a date to char in oracle? Give one example.
What is a connect identifier?
How is it different from a normal table?
What are the uses of a database trigger?
What is Segment Advisor in Oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to handle a single quote in oracle sql?
what is the difference between data migration and production migration.
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How will you write a query to get a 5th rank student from a table student_report?
What are the advantages of oracle?
How to install oracle odbc drivers?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is the disadvantage of User defind function?
