2008-07-29 18:36:21 / Oracle数据库管理
平台：windows数据库：oracle10.2.0.1 not rac not dataguard过程：exec dbms_logmnr_d.build(dictionary_filename=>'dic.ora',dictionary_location=>'d:logminer');exec dbms_logmnr.add_logfile(logfilename=>'D:softwareoracleproduct10.2.0oradataorclarchARC00005_0661086094.001', options=>dbms_logmnr.new);exec dbms_logmnr.start_logmnr(dictfilename=>'d:logminerdic.ora');select to_char(timestamp,'yyyy-mm-dd hh24:mi:ss'),session_info,LOG_ID,SEG_OWNER,seg_name,USERNAME,OPERATION,sql_redo,sql_
查看(489)
评论(23)
