{"id":1583,"date":"2024-05-08T14:52:32","date_gmt":"2024-05-08T06:52:32","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1583"},"modified":"2024-05-08T14:52:32","modified_gmt":"2024-05-08T06:52:32","slug":"shell%e8%b0%83%e7%94%a8%e6%88%b7sqlplus%e4%b8%8edbtool","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1583","title":{"rendered":"shell\u8c03\u7528\u6237sqlplus\u4e0edbtool"},"content":{"rendered":"

`shell\u8c03\u7528\u6237sqlplus\u4e0edbtool
\nsqlplus dbtool\u81ea\u52a8\u767b\u5f55\u811a\u672c
\n\u5206\u7c7b\uff1a Shell linux MS SQL\/Oracle\/MySql 2010-11-01 19:46 60\u4eba\u9605\u8bfb \u8bc4\u8bba(0) \u6536\u85cf \u4e3e\u62a5 <\/p>\n

shell\u4e2d\u8c03\u7528sqlplus
\nsqlplus -s user\/pwd@datebase<\/dev\/null
\nspool b.txt
\nselect * from a;
\nspool off
\nexit
\nEOF
\ncat b.txt|tr -d ''>b.txt
\nshell\u4e2d\u8c03\u7528dbtool
\n\/dxyyt\/kefu\/dbtool cxtyd_rw\/pwd@gdsm2 -f[$sqldir] afljk 1>\/dev\/null 2>&1
\ndbtool user\/password@usid sql="${proc01};${proc02};${proc03};" dbtool_password>>\/dev\/null 2>&1<\/p>\n<\/p>\n

vi FShscAudit_out_data.sh<\/p>\n

!\/usr\/bin\/sh<\/h1>\n

. \/home\/ngboss\/.profile
\ncd \/usr1\/kefu\/zjy\/fshsc
\nrm -rf .<\/em>
\ndbfs <<EOF<\/p>\n

CRM\u6821\u9a8c\u6570\u636e\uff1a<\/h1>\n

select sysdate from dual;
\nunload to FS_HSC_CU_GROUP_SIcrm.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SIcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_CU_CUSTOMERcrm.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_CA_ACCOUNTcrm.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
\nunload to FS_HSC_SUBS_SUBSCRIBERcrm.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_CA_CREDITcrm.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDITcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_CA_BILLMAILcrm.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_CA_SETTLETYPEcrm.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_BILLMAILcrm.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_RELATIONcrm.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATIONcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
\nunload to FS_HSC_SUBS_PAYPLANcrm.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLANcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_PAYBEHALFcrm.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALFcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_FORBIDcrm.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBIDcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_PRODUCTcrm.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_SUBS_PRODATTRcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_SUBS_SERVICEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_SUBS_RESOURCEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_CU_BINDNUMcrm.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_PR_MOBIMEIRELAcrm.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELAcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
\nunload to FS_HSC_CU_GROUPcrm.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUPcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_CU_GROUPMEMcrm.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_MK_CUSTMAILBILLcrm.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILLcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_GROUP_SUBSCRIBERcrm.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_GROUP_MEMBERcrm.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE from HSC_GROUP_MEMBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;<\/p>\n

HSC\u6821\u9a8c\u6570\u636e<\/h1>\n

select sysdate from dual;
\nunload to FS_HSC_CU_GROUP_SIhsc.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SI where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_CU_CUSTOMERhsc.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_CA_ACCOUNThsc.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
\nunload to FS_HSC_SUBS_SUBSCRIBERhsc.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_CA_CREDIThsc.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDIT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_CA_BILLMAILhsc.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_CA_SETTLETYPEhsc.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPE where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_BILLMAILhsc.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_RELATIONhsc.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATION where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
\nunload to FS_HSC_SUBS_PAYPLANhsc.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLAN where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_PAYBEHALFhsc.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALF where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_FORBIDhsc.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBID where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_SUBS_PRODUCThsc.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_SUBS_PRODATTRhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_SUBS_SERVICEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_SUBS_RESOURCEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_CU_BINDNUMhsc.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_PR_MOBIMEIRELAhsc.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELA where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
\nunload to FS_HSC_CU_GROUPhsc.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUP where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_CU_GROUPMEMhsc.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to FS_HSC_MK_CUSTMAILBILLhsc.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to FS_HSC_GROUP_SUBSCRIBERhsc.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to FS_HSC_GROUP_MEMBERhsc.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE FROM HSC_GROUP_MEMBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nexit
\nEOF<\/p>\n

\n

vi ZShscAudit_out_data.sh<\/p>\n

!\/usr\/bin\/sh<\/h1>\n

. \/home\/ngboss\/.profile
\ncd \/usr1\/kefu\/zjy\/zshsc
\nrm -rf .<\/em>
\ndbzs <<EOF<\/p>\n

CRM\u6821\u9a8c\u6570\u636e\uff1a<\/h1>\n

select sysdate from dual;
\nunload to ZS_HSC_CU_GROUP_SIcrm.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SIcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_CU_CUSTOMERcrm.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_CA_ACCOUNTcrm.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
\nunload to ZS_HSC_SUBS_SUBSCRIBERcrm.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_CA_CREDITcrm.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDITcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_CA_BILLMAILcrm.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_CA_SETTLETYPEcrm.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_BILLMAILcrm.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAILcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_RELATIONcrm.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATIONcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
\nunload to ZS_HSC_SUBS_PAYPLANcrm.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLANcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_PAYBEHALFcrm.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALFcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_FORBIDcrm.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBIDcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_PRODUCTcrm.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_SUBS_PRODATTRcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_SUBS_SERVICEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_SUBS_RESOURCEcrm.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_CU_BINDNUMcrm.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_PR_MOBIMEIRELAcrm.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELAcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
\nunload to ZS_HSC_CU_GROUPcrm.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUPcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_CU_GROUPMEMcrm.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEMcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_MK_CUSTMAILBILLcrm.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILLcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_GROUP_SUBSCRIBERcrm.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_GROUP_MEMBERcrm.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE from HSC_GROUP_MEMBERcrm where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;<\/p>\n

HSC\u6821\u9a8c\u6570\u636e<\/h1>\n

select sysdate from dual;
\nunload to ZS_HSC_CU_GROUP_SIhsc.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SI where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_CU_CUSTOMERhsc.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_CA_ACCOUNThsc.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by ACCTID;
\nunload to ZS_HSC_SUBS_SUBSCRIBERhsc.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_CA_CREDIThsc.bak select OID,ACCTID,STARTDATE,ENDDATE,REGION,DELAY_HOUR,CREDIT from HSC_CA_CREDIT where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_CA_BILLMAILhsc.bak select OID,ACCTID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,STATUS,STATUSDATE,CREATEDATE,REGION,LANGTYPE from HSC_CA_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_CA_SETTLETYPEhsc.bak select OID,ACCTID,BANKID,BANKACCT,ACCTTYPE,ACCTNAME,STATUS,STATUSDATE,PAYTYPE,CREATEDATE,REGION,DRAWTYPE,DRAWAMT,TRIGAMT,PAYORDER,STARTDATE,MAXDRAWAMT,CERTTYPE,CERTID,CONTRACTID,BANKPROVINCE,NAME,PREPAYTRANSFERSETUP,PREPAYTRANSFERMOD,PREPAYTRANSFERDATE,PREPAYTRANSFERSUM from HSC_CA_SETTLETYPE where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_BILLMAILhsc.bak select OID,BILLTYPE,MAILTYPE,MAILADDR,POSTCODE,LINKMAN,LINKPHONE,EMAIL,STATUS,STATUSDATE,CREATEDATE,SUBSID,REGION,LANGTYPE from HSC_SUBS_BILLMAIL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_RELATIONhsc.bak select RELATEID,REGION,SUBSID,RELATETYPE,ISPRIMA,STARTDATE,APPLYOID,ENDDATE,CANCELOID,OPREGION,SERVNUMBER from HSC_SUBS_RELATION where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by RELATEID;
\nunload to ZS_HSC_SUBS_PAYPLANhsc.bak select OID,ACCTID,SUBSID,FEEGROUPID,GRPSUBSID,SUBJECTID,CYCLENUM,DRAWMETHOD,PAYLIMIT,DRAWVALUE,ISOWE,OWERATE,DRAWORDER,APPLYOID,STARTDATE,ENDDATE,PAYPLANPAUSE,REGION from HSC_SUBS_PAYPLAN where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_PAYBEHALFhsc.bak select OID,SUBSID,ACCTID,SERVNUMBER,PRODID,PAYMODE,PAYAMT,PAYTYPE,OTHERREGION,STARTDATE,ENDDATE,APPLYOID,REGION,CANCELOID from HSC_SUBS_PAYBEHALF where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_FORBIDhsc.bak select OID,SUBSID,FORBIDTYPE,RECDEFID,STARTDATE,ENDDATE from HSC_SUBS_FORBID where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_SUBS_PRODUCThsc.bak select SUBSID,REGION,SUBSPRODID,PRODID,PACKAGEID,TARIFFITEMID,STANDARDTARIFF,PRICE,STARTDATE,ENDDATE,GROUPID,PACKAGEPRODID from HSC_SUBS_PRODUCTAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_SUBS_PRODATTRhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,ATTRID,ATTRVALUE,STARTDATE,ENDDATE from HSC_SUBS_PRODATTRAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_SUBS_SERVICEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,SERVSTATUS,PRODID,STARTDATE,ENDDATE from HSC_SUBS_SERVICEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_SUBS_RESOURCEhsc.bak select SUBSID,REGION,SUBSPRODOID,SERVICEID,RESCLASS,RESID,STARTDATE,ENDDATE from HSC_SUBS_RESOURCEAUVIEW where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_CU_BINDNUMhsc.bak select OID,REGION,USIMVALUE,IDVALUE,STATUS,FLAG,BINDPRIV,INTIME,ISBIND,ATTR from HSC_CU_BINDNUM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_PR_MOBIMEIRELAhsc.bak select IMEI,MOBILENO,PRODID,ENABLETIME,DISABLETIME,STATE,OPRTIME,BLMOBILENO,ZSMOBILENO from HSC_PR_MOBIMEIRELA where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by IMEI;
\nunload to ZS_HSC_CU_GROUPhsc.bak select CUSTID,REGION,GROUPID,PARENTGROUPID,CORPSCOPE,DEVELOPMAN,PAYMODE,INNETDATE,ECCODE,HOSTCITY,HOSTPROVINCE,ISCROSSPROVINCE,CREATEDATE from HSC_CU_GROUP where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_CU_GROUPMEMhsc.bak select OID,CUSTID,SERVNUMBER,SUBSCODE,IMPORTANT,ROLETYPE,REGION,STATUS from HSC_CU_GROUPMEM where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nunload to ZS_HSC_MK_CUSTMAILBILLhsc.bak select CUSTID,MAILADDR,ADDRESSEE,ADDRESSEETELE,POSTCODE,ADDRESSEEEMAIL,ISMAILLEVELBILL,ISMAILSUPPLYBILL,MAILMODEL,REGION from HSC_MK_CUSTMAILBILL where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by CUSTID;
\nunload to ZS_HSC_GROUP_SUBSCRIBERhsc.bak select SUBSID,PRODUCTCODE,BILLINGNBR,DEPENDSUBSID,STATUS,MAXMEMCOUNT,STARTDATE,ISINTERGROUP,INTERUSERID,ISSOLUTION,SOLUTIONSUBSID,INTERNALID,REGION from HSC_GROUP_SUBSCRIBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by SUBSID;
\nunload to ZS_HSC_GROUP_MEMBERhsc.bak select OID,GROUPOID,MEMTYPE,MEMSUBSID,MEMREGION,MEMSERVNUMBER,SHORTNUMBER,STARTDATE,ENDDATE,REGION,STATUS,STATUSDATE FROM HSC_GROUP_MEMBER where changedate>to_date('2012-09-08 00:00:00','yyyy-mm-dd hh24:mi:ss') and changedate<to_date('2012-09-09 00:00:00','yyyy-mm-dd hh24:mi:ss') order by OID;
\nexit
\nEOF<\/h2>\n

\/usr1\/kefu\/zjy\/ZShscAudit_out_data.sh<\/p>\n

################### \u5bf9\u8d26\u4e2d\u5c71\u51fa\u6570\u636e\u7a0b\u5e8f ########################
\n30 01 <\/em> sh \/usr1\/kefu\/zjy\/ZShscAudit_out_data.sh >> .\/ZShscAudit_out_data.log&
\n################### \u5bf9\u8d26\u4f5b\u5c71\u51fa\u6570\u636e\u7a0b\u5e8f ########################
\n30 01 <\/em> <\/em> sh \/usr1\/kefu\/zjy\/FShscAudit_out_data.sh >> .\/FShscAudit_out_data.log&<\/p>\n

FS201209081001165181 FS201209081001165180 FS201209081001165177<\/p>\n

ZS201209081001149989 <\/p>\n

`<\/p>\n","protected":false},"excerpt":{"rendered":"

`shell\u8c03\u7528\u6237sqlplus\u4e0edbtool sqlplus dbtool\u81ea\u52a8\u767b\u5f55\u811a\u672c \u5206\u7c7b\uff1a Shell linux MS SQL\/Oracle\/MySql 2010-11-01 19:46 60\u4eba\u9605\u8bfb \u8bc4\u8bba(0) \u6536\u85cf \u4e3e\u62a5 shell\u4e2d\u8c03\u7528sqlplus sqlplus -s user\/pwd@datebase<\/dev\/null spool b.txt select * from a; spool off exit EOF cat b.txt|tr -d ”>b.txt shell\u4e2d\u8c03\u7528dbtool \/dxyyt\/kefu\/dbtool cxtyd_rw\/pwd@gdsm2 -f[$sqldir] afljk 1>\/dev\/null 2>&1 dbtool user\/password@usid sql="${proc01};${proc02};${proc03};" dbtool_password>>\/dev\/null 2>&1 vi FShscAudit_out_data.sh !\/usr\/bin\/sh . \/home\/ngboss\/.profile cd \/usr1\/kefu\/zjy\/fshsc rm -rf . dbfs <<EOF CRM\u6821\u9a8c\u6570\u636e\uff1a select sysdate from dual; unload to FS_HSC_CU_GROUP_SIcrm.bak select CUSTID,GROUPID,SICODE,STATUS,REGION from HSC_CU_GROUP_SIcrm where changedate>to_date(‘2012-09-08 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) and changedate<to_date(‘2012-09-09 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) order by CUSTID; unload to FS_HSC_CU_CUSTOMERcrm.bak select CUSTID,CUSTTYPE,VIPTYPE,CUSTCLASS1,CUSTCLASS2,LINKPHONE,HOMETEL,OFFICETEL,MOBILETEL,POSTCODE,EMAIL,CREDITLEVEL,STATUS,REGSTATUS,REGION,CUSTNAME,FOREIGNER,CERTID,CERTTYPE,CERTADDR,LINKMAN,LINKADDR,ISMERGEBILL,OWNERAREAID,ORGID,RESPONSECUSTMGR,CURRENTCUSTMGR,CREATEDATE,STATUSDATE from HSC_CU_CUSTOMERcrm where changedate>to_date(‘2012-09-08 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) and changedate<to_date(‘2012-09-09 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) order by CUSTID; unload to FS_HSC_CA_ACCOUNTcrm.bak select ACCTID,CUSTID,ACCTNAME,PREPAYTYPE,INVOICETEL,ACCTTYPE,ORGID,STATUS,REGION,GROUPACCTID,OVERDRAFT,CONTROLSCHEME,NOTIFYTYPE,NOTIFYVALUE,INVPRINTTYPE,STATUSDATE from HSC_CA_ACCOUNTcrm where changedate>to_date(‘2012-09-08 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) and changedate<to_date(‘2012-09-09 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) order by ACCTID; unload to FS_HSC_SUBS_SUBSCRIBERcrm.bak select SUBSID,REGION,CUSTID,SUBSNAME,SERVNUMBER,AUTHTYPE,PASSWORD,BRAND,PRODID,CREATEDATE,STARTDATE,INVALIDDATE,PAYMODE,ACCTID,STOPKEY,STATUS,STATUSDATE,ISDEFAULTNUM from HSC_SUBS_…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[88,82],"tags":[],"class_list":["post-1583","post","type-post","status-publish","format-standard","hentry","category-oracle","category-82"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1583"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1583\/revisions"}],"predecessor-version":[{"id":1584,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1583\/revisions\/1584"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}