使用sqlplus将oracle执行结果输出到文件上
无法创建spool文件 是因为没有用管理员运行CMD,并且数据库不需要使用超级管理员登录。
sqlplus test/test123@publicdb;
spool on;
set heading off;
spool $HOME/testspool.txt;
select sysdate from dual;
spool off;
Oracle LogMiner用法详解
http://blog.sina.com.cn/s/blog_61cd89f60102e9kw.html
select current_scn from v$database;
INSERT INTO EMP(EMPNO,ENAME) VALUES(301,'xmm')
select l.STATUS, lf.MEMBER from v$log l, v$logfile lf where l.GROUP# = lf.GROUP#;
alter system dump logfile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' scn min 1052696 scn max 1052707;
oradebug tracefile_name;
E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
show parameter user_dump_dest;
execute dbms_logmnr.add_logfile(logfilename=>'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG',options=>dbms_logmnr.new);
execute dbms_logmnr.add_logfile(logfilename=>'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG',options=>dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename=>'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG',options=>dbms_logmnr.addfile);
execute dbms_logmnr.remove_logfile(logfilename=>'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG');
execute dbms_logmnr.remove_logfile(logfilename=>'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG');
execute dbms_logmnr.remove_logfile(logfilename=>'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG');
execute dbms_logmnr.start_logmnr(Options => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
select username,scn,timestamp,sql_redo from v$logmnr_contents;
execute dbms_logmnr.end_logmnr(Options => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);