Interested to Buy Any Domain ? << Click Here >> for more details...
Can we get the deleted Record again if the delete
transaction has been committed.
- 4 Answers
- 6922 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kd
Using flashback query
select * from t1 as of scn 1234567;
Using flashback transaction query to get undo sql.
Using flashback table to scn/timestamp
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / david
@SWATI....
may i know how will u get this ...explanation plzzzz....
gunjan david.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / swati
Yes we can get the deleted Record again if the delete
transaction has been committed. Since delete is a DML
command, so it can be triggered back, as well as Rolled
back also.
| Is This Answer Correct ? | 1 Yes | 5 No |
How would you go about increasing the buffer cache hit ratio?
What command would you use to create a backup control file?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
please explain about oracle
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
what is the difference b/w oracle8i and oracle9i
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
How would you determine the time zone under which a database was operating?
What is the difference between conversions and interfaces? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
What is $FLEX$ and $PROFILES$?
What do you mean by hz_ in customer tables? : oracle accounts receivable
Oracle General 
