摘要: expdp cjcl/cjclpassword directory=dumpdir schemas=cjcl,zhyy,aqdb cluster=n dumpfile=zhtfzd-%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%-%U.dmp parallel=5 logfile=log-%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.logforfil... 阅读全文
posted @ 2013-09-25 14:48 -Bill 阅读(524) 评论(0) 推荐(0) 编辑
摘要: SELECT COUNT(0) FROM cjcl.cj_cj_tbjd where bgq = '201308MM'; --RWID_601_BGQ_201309MMSELECT COUNT(0) FROM cjcl.cj_cj_tbjd SUBPARTITION (RWID_601_BGQ_201308MM)ALTER TABLE cjcl.cj_cj_tbjd TRUNCAT... 阅读全文
posted @ 2013-09-25 14:40 -Bill 阅读(364) 评论(0) 推荐(0) 编辑