sh oracle导出数据库,Linux sh脚本用spool导出oracle数据库指定表表数据

#!/bin/bash2

3 cd /opt/oracle/datafor_kf4

5 #redirect environment variables6 source /opt/oracle/.bash_profile7

8 #timestamp:YYYYmmdd9 fdate=`date +%Y%m%d`10

11 localGtFile="tcm_local_gtt_list_$fdate.txt"

12 allGtFile="tcm_all_gtt_list_$fdate.txt"

13 ecFile="tcm_ec_smsc_server_$fdate.txt"

14 spFile="tcm_sp_smsc_server_$fdate.txt"

15

16

17 #login

18 /opt/oracle/app/oracle/product/12.2.0/dbhome_1/bin/sqlplus uid/pwd@hostname:port/db<

23 SET linesize 5000

24 SET verify off25 SET term off26 SET trims ON27 SET heading off28 SET trimspool ON29 SET trimout ON30 SET timing off31

32

33 --tcm_local_gtt_list34 spool "/home/ftp_kf/$localGtFile"

35 SELECT province||‘,‘||busi_city||‘,‘||area_code||‘,‘||gt||‘,‘||bel_hlr||‘,‘||spc||‘,‘||ser_type from TCM_GMSCSERVER_GT;36 spool off37

38

39 --tcm_all_gtt_list40 spool "/home/ftp_kf/$allGtFile"

41 --used42 SELECT province||‘,‘||busi_city||‘,‘||area_code||‘,‘||start_gt from TCM_CMCC_DATA_JT;43 --test44 --SELECT province||‘,‘||busi_city||‘,‘||area_code||‘,‘||start_gt from TCM_CMCC_DATA_JT where start_gt=‘1348803‘;45 spool off46

47

48 --tcm_ec_smsc_server49 spool "/home/ftp_kf/$ecFile"

50 --used51 SELECT SERVER_CODE||‘,‘||EC_NAME||‘,‘||MAIN_ACCESS_ADDR||‘,‘||‘hy‘type from HY_SMGATE;52 --test53 --SELECT SERVER_CODE||‘,‘||EC_NAME||‘,‘||MAIN_ACCESS_ADDR||‘,‘||‘hy‘ type from HY_SMGATE where SERVER_CODE=‘10037‘;54 spool off55

56

57 --tcm_sp_smsc_server58 spool "/home/ftp_kf/$spFile"

59 SELECT SERVER_CODE||‘,‘||SP_CONTENT_NAME||‘,‘||MAIN_ACCESS_ADDR from TCM_SP_NETGATE;60 spool off61

62

63 exit64 EOF65

66 #del line where it start by ‘SQL‘

67 /bin/sed -i ‘/SQL/d‘$localGtFile68 /bin/sed -i ‘/SQL/d‘$allGtFile69 /bin/sed -i ‘/SQL/d‘$ecFile70 /bin/sed -i ‘/SQL/d‘$spFile71

72 #del filebefore today73 /bin/find /home/ftp_kf/*-mtime +1 -exec rm {} \;

Linux sh脚本用spool导出oracle数据库指定表表数据

标签：bho   exe   pre   serve   inux   data   set   数据   数据库

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：https://www.cnblogs.com/jack-Leo/p/10085610.html