Oracle Restore mistakenly deleted tables and incorrectly updated tables

According to ORACLE10G's characteristics, when I execute the drop table or delete all, Oracle places the deleted table or data record in the database Recycle Bin (db RecycleBin). So we can use the Flashback Table command to recover the deleted table syntax:

Flashback table name to before drop;

Table test003 to before drop;

Flashback complete.

* FROM test003;

NAME State Person

---- ---------- ----------

A 1

A 2

A 1

A 1

B 2

B 2

6 rows selected.

Table for Update

Table A to timestamp to_timestamp (' 2009-11-09 11:00:00 ', ' yyyy-mm-dd hh24:mi:ss ');

The general error is:

ERROR at line 1:

Ora-08189:cannot Flashback the table because row movement is not enabled

Only need:

Table a enable row movement;

Table altered.

It's OK.

Table A to timestamp to_timestamp (' 2009-11-09 11:00:00 ', ' yyyy-mm-dd hh24:mi:ss ');

Flashback complete.

* from A;

NAME NUM

-------------------- ----------

Jim 90

Tom 100

Kate 220

Lily 330

[sys@ora10gr1#2009-11-04/08:42:53] Sql>show parameter Db_flashback_retention_target

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Db_flashback_retention_target integer 1440

By default, Oracle does 1440 minutes on the submitted data, which is the "cache" of the day, so the data within a day is available.