一個資料倉儲資料重新整理的實現機制（二）

表eden_refr_log，記錄資料重新整理資訊[@more@]

SQL> desc eden_refr_log
Name          Type           Nullable Default Comments
------------- -------------- -------- ------- --------
USER_NAM      VARCHAR2(30)                            
OBJ_NAM       VARCHAR2(50)                            
OBJ_TYPE      CHAR(1)        Y                        
REFR_SEQ_NB   NUMBER                                  
STRT_DAT_TIM  DATE           Y                        
END_DAT_TIM   DATE           Y                        
TOT_DRTN_TIM  NUMBER         Y                        
ROWS_BEF_REFR NUMBER         Y                        
ROWS_AFT_REFR NUMBER         Y                        
ERR_TXT       VARCHAR2(2000) Y                        
STA_COD       CHAR(1)        Y                        

 

 select * from eden_refr_log order by strt_dat_tim desc

USER_NAM	OBJ_NAM	OBJ_TYPE	REFR_SEQ_NB	STRT_DAT_TIM	END_DAT_TIM	TOT_DRTN_TIM	ROWS_BEF_REFR	ROWS_AFT_REFR	ERR_TXT	STA_COD
edende	eden_flat_vhc_live_cmpt	P	17	2005-4-7 7:02		0	19533	0	ORA-01841: (full) year must be between -4713 and +9999, and not be 0	N
edenfr	eden_vhc_extr_mv	T	78	2005-4-7 5:52	2005-4-7 5:53	44	219380	219448		Y
edenfr	eden_flat_vhc_live_rate	P	78	2005-4-7 5:36	2005-4-7 5:52	960	73207	73507		Y