数据库相关

oracle库导出

set mydate=%DATE:~0,10%
expdp choiceall/choiceall@choicedb directory=dump_dir dumpfile=QJDbackup_%mydate%.dmp full=y;
forfiles /p "D:\databak\dump" /s /m *.dmp /d -7 /c "cmd /c del @path"

备份表

create table xxx_bak as select * from xxx;