#!/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