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
- 12799 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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 |
What is a data segment ?
Explain the use of grant option in exp command.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
how can we store any pdf file in oracle
Can we convert a date to char in oracle and if so, what would be the syntax?
What happens in oracle commit?
How do I know if oracle client is installed on windows?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
What are the advantages of oracle?
Can a Tablespace hold objects from different Schemes ?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
Oracle General 
