--update refresh dates to re-fresh data for these
tables
update w_etl_table_dt tbl_dt
set last_refresh_dt = null
where exists
(select 'x' from w_etl_table tbl, w_etl_dbconn dbconn
where tbl_dt.table_wid = tbl.row_wid
and dbconn.row_wid = tbl_dt.dbconn_wid
and dbconn.name = 'OLTP'
and tbl.name in ('S_DOC_AGREE','S_AGREE_ITEM'));
In this in place of in ('S_DOC_AGREE','S_AGREE_ITEM')
you should change and do it for all the S_ tables.
Also instead of set last_refresh_dt = null set set
last_refresh_dt = <2 year ago>.
You can then see the SQL in Change capture phase to
check if this is really working.
Posts