oracle 删除指定分区表,oracle 分区表定期删除分区

---删除6个月前的分区(local主键、索引)

[[email protected] ~]$ cat /home/oracle/del_t_test_aa.sh

#!/bin/bash

source /home/oracle/.bash_profile

DEL_DATE=$(date -d ‘6 month ago‘ +%Y%m)

#DEL_DATE=$(date +%Y%m)

PARTINAME="P"${DEL_DATE}

echo $PARTINAME

exec >> /home/oracle/del_t_test_aa`date +%y%m%d%H`.log

sqlplus / as sysdba << EOF

set timing on

--select sysdate from dual;

ALTER TABLE test._t_test_aa DROP PARTITION $PARTINAME UPDATE GLOBAL INDEXES PARALLEL 4;

exit;

EOF

[[email protected] ~]$ DEL_DATE=$(date -d ‘6 month ago‘ +%Y%m)

[[email protected] ~]$ PARTINAME="P"${DEL_DATE}

[[email protected] ~]$ echo $PARTINAME

P201711

原文：https://www.cnblogs.com/ss-33/p/8989507.html