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 get last row id?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
Can a Tablespace hold objects from different Schemes ?
What happens to the data files if a tablespace is dropped?
What are internal user account in oracle?
Is java required for oracle client?
how do get database name at sql prompt?
What is meant by a deadlock situation?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
How to drop an existing table in oracle?
Point the difference between translate and replace?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.