tables.lst

sqlplus -S "/ as sysdba" >/dev/null <<EOF
set echo off
set termout off
set feedback off
set heading off
set linesize 120
set pagesize 0

--select to_char(sysdate,'''yyyy-mm-dd hh:mm:ss''') from dual;
spool /home/oracle/tables.lst
SELECT 'tables=(' || CHR (10) FROM DUAL;
SELECT owner || '.' || table_name || ',' || CHR (10)
FROM dba_tables
WHERE owner NOT IN ('SYS', 'SYSTEM', 'CTXSYS', 'ORDSYS', 'MDSYS')
AND table_name NOT IN
('SMS_LOG','SMS_RESPREPT_ERROR','SMS_STATUSREPT','PUSH_USER_INFO_LOG')
ORDER BY owner;
--SELECT 'SYS.DUAL' FROM DUAL;
SELECT ')' FROM DUAL;
spool off
EOF

然后定义一个包含不变参数的参数文件，这个文件名为exp_temp.parfile，这个文件的内容类似：

userid=username/passwd
filesize=2046M
file=(/u02/backup/oracle/expfull/fulldmp1.dmp,/u02/backup/oracle/expfull/fulldmp2.dmp,…..,/u02/backup/oracle/expfull/fulldmp15.dmp)
rows=y
log=/usr/oracle/backup/expfull.log
compress=n
buffer=40960000
direct=y

cat /usr/oracle8/backup/exp_temp.parfile > /usr/oracle8/backup/expfull.parfile
cat /usr/oracle8/backup/tables.lst >> /usr/oracle8/backup/expfull.parfile

start_exp.sh

BACK_HOME=/u02/backup/oracle
BACK_DEST=$BACK_HOME/expfull
SH_HOME=/usr/oracle/backup

DATE=`date +%m%d:%H.%M`
IP="11.15.112.19"
exp_log_file=$SH_HOME/expfull.log
MAIL_COMMAND=/usr/bin/mailx

$ORACLE_BIN/exp parfile=$SH_HOME/expfull.parfile;


expfull.sh
/usr/oracle/backup/tables.sh
cat /usr/oracle/backup/exp_temp.parfile > /usr/oracle/backup/expfull.parfile
cat /usr/oracle/backup/tables.lst >> /usr/oracle/backup/expfull.parfile
/usr/oracle/backup/start_exp.sh

oracle >crontab -l
30 1 * * * /oracle/oracle/backup/expfull.sh