Oracle spool操作

发表于 2020-09-30 | 更新于 2020-11-19 | 分类于 Oracle | 阅读次数：

| 字数： 611 | 时长 ≈ 1 分钟

#!/bin/ksh
echo "set echo off;
set heading off;
set line 100;
set long 2000000000;
set longchunksize 255;
set wra on;
set newpage none;
set pagesize 0;
set numwidth 12;
set termout off;
set trimout on;
set trimspool on;
set feedback off;
set timing on;
execute dbms_logmnr.add_logfile(LogFileName=>'/oracle/app/oracle/logs/hrbfct_1_4156_748575599.arc',Options=>dbms_logmnr.new);
execute dbms_logmnr.start_logmnr(DictFileName=>'/oracle/app/oracle/logs/dict.ora');
spool /oracle/app/oracle/logs/record3.txt;
select id||'|'||name from t_user;
spool off;
" | sqlplus '/as sysdba'>/dev/null