Oracle Table Error Update (flashback) Flash back operation

--oracle Table Error Update flashback operation test Environment

--select * from V$database;

--select * from V$version;

The first step of operation

1. Enable row migration with the following command

ALTER TABLE test_a enable row movement;

2. The following command flashes back to a certain point in time

Flashback table Test_a to timestamp to_timestamp (' 2012-05-31 16:20:30 ', ' yyyy-mm-dd hh24:mi:ss ');

3 The following command queries the SQL operations log to see when the executed statement was executed

SELECT * from V$sql ORDER by first_load_time Desc;

SELECT * from V$sql (#查看最近所作的操作)

SELECT * from V$sqlarea (#查看最近所作的操作)

Oracle Table Error Update (flashback) Flash back operation