This content has been marked as final. Show 4 replies
Thanks Veeravalli for Suggesion!
Tried adding Task action Refresh MV as action type "Success Action" for Fact task .. It did add a step of Refresh MV for load Fact Task in EP
But it is passing the Orgininal Factable name as to be refreshed as MV which is giving DB error.
"Refresh MV" for WC_B_TEST_F failed on "DataWarehouse"
DBMS_STATS.GATHER_TABLE_STATS(ownname => 'olap', tabname=> 'WC_B_TEST_F',cascade => FALSE, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'FORALL COLUMNS SIZE AUTO', degree => DBMS_STATS.DEFAULT_DEGREE);
Error: MESSAGE:::ORA-23401: materialized view "OLAP"."WC_B_TEST_F" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
ORA-06512: at line 2
instead of WC_B_TEST_F, we wanted "OLAP"."WC_B_TEST_MV" to be refreshed
Do we need to create another task for MV refresh rather than task action? and add Refresh MV as task action there?
No dac functions are available to get the related tables, try defining a task (Fact load task) level parameter and use the same
in the action template.
Task level parameter
And change the action template to refer the parameter as below and include the action in the task with action type as success
DBMS_STATS.GATHER_TABLE_STATS(ownname => 'getTableOwner()', tabname=> '@DAC_MV_NAME_1', cascade => TRUE, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => 'FOR ALL COLUMNS SIZE AUTO', degree => DBMS_STATS.DEFAULT_DEGREE);
pls mark if helps