oracle记录成用户的日志,oracle日志记录

【例1】

SQL>set time on

SQL>create table hr.mydep1 as select * from hr.department;

SQL>delete from hr.mydep1 where department_id=10;

SQL>flashback table hr.mydep1 to timestamp

2 to timestamp(to_tate(‘2009-05-29 10:00:00’, ’yyyy-mm-dd hh24:mi:ss’));

【例2】

SQL>create table student (name Varchar2(10), score Number);

SQL>insert into student values(‘zs’, 68);

SQL>update student set score=98 where name=’zs’;

SQL>commit;

SQL>select versions_starttime,versions_operation,name,score

2 from student versions between timestamp minvalue and maxvalue;

【例3】

SQL>CONNECT sys /zzuli AS sysdba

SQL>select table_name, undo_sql from flashback_transaction_query where rownum<5;