BEGIN
DBMS_STATS.SET_TABLE_PREFS (
ownname
=>
'HMA_TM_PROD_GEN2_MONITOR'
, tabname => 'ZZT_SERVICE_LOG'
, pname => 'INCREMENTAL'
, pvalue => 'true'
);
END;
--This
should return True. This mean incremental is enabled
select dbms_stats.get_prefs('INCREMENTAL','HMA_TM_PROD_GEN2_MONITOR','ZZT_SERVICE_LOG') from dual;
BEGIN
DBMS_STATS.GATHER_TABLE_STATS (
ownname
=> 'HMA_TM_PROD_GEN2_MONITOR'
, tabname => 'ZZT_SERVICE_LOG'
);
END;
/
