2016年9月21日
check_partition_aft_merge.sql
摘要： spool ./05_check_partition_aft_merge.log @/tmp/rda/chk_freets set echo on feedback on set pagesize 400 set linesize 200 col owner for a10 col segment_ 阅读全文
posted @ 2016-09-21 16:45 feiyun8616 阅读(201) 评论(0) 推荐(0) 编辑
copy_part_stat.sql
摘要： spool 04_copy_part_stat.log conn / as sysdba execute sys.dbms_stats.export_schema_stats(ownname=>'test',statown=>'OPER',stattab=>'STAT_TABLE',statid=> 阅读全文
posted @ 2016-09-21 16:43 feiyun8616 阅读(272) 评论(0) 推荐(0) 编辑
idx_rebuild_diff_idx_l.sql
摘要： 1. set echo on feedback on set timing on set time on set pagesize 1000 set linesize 150 spool 02_do_index_idx_l.log @/testdb/change/env/env_test.sql c 阅读全文
posted @ 2016-09-21 16:38 feiyun8616 阅读(155) 评论(0) 推荐(0) 编辑
merge_partition
摘要： set echo on time on timing on spool 01_merge_partition.log @/testdb/change/env/env_test.sql connect &V_testDATA_UN/&V_testDATA_PW show user select ind 阅读全文
posted @ 2016-09-21 16:33 feiyun8616 阅读(333) 评论(0) 推荐(0) 编辑