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.

How to import one table back from a dump file?

0 Answers  

How to get execution path reports on query statements?

0 Answers  

What are the logical operations?

0 Answers  

Can a parameter be passed to a cursor?

0 Answers  

How do I know if oracle is installed on windows?

0 Answers  

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 Answers  

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

5 Answers  

How to assign a table row to a record variable?

0 Answers  

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

3 Answers  

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,