有时需把QC中缺陷清理一下,特别是在开始时,做模板,新增了些缺陷样例,等到正式使用时,要清除前期的缺陷,但BUGID号并不是从零开始;
使用SQL语句如下:
-- 注 default_bafe_db是新建立缺陷库的用户,组合为 域_QC库名_DB
-- 可以使用 select * from all_users t1 where t1.username like 'D%DB%'; 查询出有哪些库;
delete from default_bafe_db.BUG_TOKENS;
delete from default_bafe_db.AUDIT_PROPERTIES;
delete from default_bafe_db.BUG_MULTIVALUE ;
delete from default_bafe_db.AUDIT_LOG ;
delete from default_bafe_db.ALERT ;
delete from default_bafe_db.LOCKS ;
delete from default_bafe_db.LINK ;
delete from default_bafe_db.BUG;
update default_bafe_db.sequences t1 set t1.sq_seq_value=0 where t1.sq_seq_name='BUG' OR T1.SQ_SEQ_NAME='TOKEN';
COMMIT;