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 |
How to use "in" parameter properly?
What are the Characteristics of Data Files ?
Explain about functional dependency and its relation with table design?
How many types of synonyms in Oracle?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
When do we use group by clause in a sql query?
How to create a testing table in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
What are the differences between char and varchar2 in oracle?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What is a Private Synonyms ?