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
- 12715 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
Difference between hot backup vs. Cold backup?
What do you understand by a database object?
How to convert dates to characters in oracle?
Explain table?
What privilege is needed for a user to connect to oracle server?
Explain the use of file option in exp command.
How to create a new table in oracle?
What is catalog in Oracle?
How to pass a cursor variable to a procedure?
What is oracle data type?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How do you find current date and time in oracle?
How to convert numbers to characters in oracle?
How to use subqueries with the in operator using oracle?
What is oracle latest version?
