[MDB] 清理历史数据

mdb拆分数据清理

zg/ngboss4,123@ngtst02

select 'drop table ' ||TABLE_NAME ||';' from all_tables where table_name LIKE 'FYL_%';

 

---

---

---

入库详单清理

jf/jf@ngtstdb196

select * from dba_segments where owner  in ('CP','ZG','JF1','JF') AND segment_name LIKE 'DR_%' ORDER BY BYTES DESC;