摘要： Linux下可以使用循环脚本进行对oracle定时备份，也可以用crontab。在Windows下，就是用windows的定时计划了，定时执行批处理文件。步骤：1.创建批处理文件文件内容：exp user/passwd@instancename full=y file=d:\%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.dmp log=d:\%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.log2.打开Windows，开始 阅读全文

摘要： --删除重复数据只留一条delete from t_kpi_province_m where id not in (select max(id) from t_kpi_province_m t group by t.指标)--删除重复数据delete from t_kpi_province_m where id not in (select (id) from (select max(id) as id, t.城市, t.类型, t.日期, t.指标 from t_kpi_city_d t wher... 阅读全文