Answer Posted / 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.

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

---

How to omit columns with default values in insert statement in oracle?

1046

---

Define oracle database

1045

---

How to write date and time interval literals in oracle?

1036

---

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?

2149

---

What is index in Oracle?

1074

---

How do we create privileges in oracle?

1047

---

What are the logical operations?

1125

---

What is the purpose of save points in oracle database?

1119

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2256

---

What is a snapshot in oracle database?

1025

---

How to convert numbers to characters in oracle?

1030

---

How to use an explicit cursor without open statements?

1055

---

How to define a procedure inside another procedure?

1024

---

How would you begin to troubleshoot an ORA-3113 error?

2079

---