LOGMNR包挖掘在线日志(3)

SQL> select scn,timestamp,log_id,seg_owner,seg_type,table_space,data_blk#,data_obj#,data_objd#,session#,serial#,username,session_info,sql_redo,sql_undo 
2 from v$logmnr_contents t
3 where t.sql_redo like 'create%';