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;

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

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.

Answer / manojkumar

Wow really excellent.(Asnani_satish,Bipin ,serena)
Thanks a lot

Answer / venkata

No,But some limitation time ... we can get a DBA

Answer / yash

NO We can't get back those records once commit has been done.

Answer / kishore

NO We can't get back those records once commit has been done.

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

How to sort the query output in oracle?

0 Answers  

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

Explain view?

0 Answers  

Explain the use of online redo log files in oracle.

0 Answers  

How to rename an index?

0 Answers  

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

Explain the family trees and connection by clause

0 Answers  

pls explain connect by prior with example and its real time use

3 Answers  

diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,