方法3: alter table activate not logged initially with empty table; --把表变成 not logged ,怎么把表变回logged 呢? reorg table table_name ;
想征求一个比较好的方法 ,我在一个表里维护了要删除表的信息 t_delete_manage表里维护了一下信息 TNAME(不好意思,表名替换一下) DELETE_COL DELETE_PERIOD a BUSINESSDAY 90 b BUSINESSDAY 90 c BUSINESSDAY 90 d BUSINESSDAY 90 e FILE_RECEIVED_TIME 90 f FILE_RECEIVED_TIME 90 根据这个表里的信息,组成sql 进行 删除操作 我写了这么个储存过程 CREATE OR REPLACE PROCEDURE CRB_TEST () LANGUAGE SQL BEGIN declare sqlcode integer default 0; -- declare v_notfound integer default 0; -- declare v_tname varchar(50);-- declare v_delete_col varchar(30); -- declare v_delete_rows integer;-- declare v_delete_log varchar(100);-- declare v_delete_period integer;-- declare sqlStr varchar(300);-- declare condition1 varchar(100);-- declare n_is_partition integer;-- declare fetchSeqCursor cursor for select tname,delete_col,delete_period,IS_PARTITION from tsy_delete_manage order by tname;--
declare CONTINUE handler for NOT FOUND set v_notfound = 100; -- set v_notfound = 0;-- open fetchSeqCursor;-- fetch fetchSeqCursor into v_tname, v_delete_col,v_delete_period,n_is_partition;-- WHILE v_notfound=0 DO
set v_notfound = 0;-- fetch fetchSeqCursor into v_tname, v_delete_col,v_delete_period,n_is_partition;-- end WHILE;-- close fetchSeqCursor;-- END commit;