Why is undosql not displayed when oracle uses flashback ?, Flashbackundosql
Why is undosql not displayed when oracle uses flashback?
This is because oracle11g does not enable this function. Use the Administrator sys (that is, sysdba) to execute the following statement to alter databases add supplemental log data. If we want to restore some data, run (view the incorrect SQL statement. For example, we accidentally deleted a piece of data from the test table, and then copied the insert statement from the following results and executed it) select undo_ SQL from flashback_transaction_query where table_name = 'test'; # note that the table names after where in oracle must be in uppercase, otherwise, the system will prompt that the table cannot be found. The previous result is the latest operation. The scott user's test table will be restored to the data flashback select * from scott 10 minutes ago. test to timestamp sysdate-10/1440; accidentally delete a database table, use flashback to restore create table test (a int) tablespace USERS; subsequent tablespace cannot be missing, otherwise, you cannot enter the recycle bin drop table test; flashback table test to before drop; the data in the original database table is also restored.