create_index

echo "#/bin/sh" >>/app/airflow/tmp_index.sh&&echo "sqlplus -s dcm/dcm_CbPc1@dcsdb.oracle.ccdcpro:11521/dcsdb<<EOF" >>/app/airflow/tmp_index.sh&&echo "create index DCS_RESERVED_DATA_RNSCB_INDEX on DCS_RESERVED_DATA_RNSCB (ZQDM,SJ,CJRQ) tablespace DCMEXT_DATA" >>/app/airflow/tmp_index.sh&&echo "/" >>/app/airflow/tmp_index.sh&&echo "EOF" >>/app/airflow/tmp_index.sh
cat /app/airflow/tmp_index.sh
sh /app/airflow/tmp_index.sh
rm -rf /app/airflow/tmp_index.sh

posted @ 2020-12-21 15:26  rjm123456  阅读(109)  评论(0)  编辑  收藏  举报