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;
[MDB] 清理历史数据
原文:http://www.cnblogs.com/fanyl5/p/4791018.html