i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
Answers were Sorted based on User's Feedback
Answer / serena
Using flashback table:
# enable row movement
1) alter table test2 enable row movement;
# flashback test2 to 10 minutes ago.
2) FLASHBACK TABLE test2 TO TIMESTAMP SYSTIMESTAMP -
INTERVAL '10' MINUTE;
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / bipin maurya
first of all u can executed first query after that u can executed sec query
ALTER TABLE table2 ENABLE ROW movement
flashback TABLE table2 TO timestamp systimestamp-interval
'100' minute
Thanks
Bipin Maurya
Mo-+919812630225
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / manojkumar
Wow really excellent.(Asnani_satish,Bipin ,serena)
Thanks a lot
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venkata
No,But some limitation time ... we can get a DBA
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / yash
NO We can't get back those records once commit has been done.
Is This Answer Correct ? | 15 Yes | 18 No |
Answer / kishore
NO We can't get back those records once commit has been done.
Is This Answer Correct ? | 1 Yes | 5 No |
"primary key=unique+null" is equal,reson?not,reason?
How to get maxsal , minsal, ename department wise in single query
When do I need to use a semicolon vs a slash in oracle sql?
What are the various constraints used in oracle?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
What is the difference between post-database commit and post-form commit?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
What is the difference between an Oracle Schema and an Oracle Instance?
How to calculate date and time differences in oracle?
How to Identify the previously inserted/updated records in already populated table.
Will you be able to store pictures in the database?