I updated a table in a materialized view and tried to execute this procedure DBMS_MVIEW.REFRESH_DEPENDENT(super,'EMP',' ',FALSE,FALSE)
but keep getting the following error messages:
line 2, column 32:
PLS-00201: identifier 'SUPER' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
Can anyone tell me how to resolve this or declare 'SUPER'
Thanks for the suggestion but it didn't work. I also querried the dba_view_analysis but the materialized view wasn't there. I think the materialized wasn't registered in the first place. Can you tell me why and if possible how to register it. The materialized view was created.
The following parameters are needed to execute DBMS_MVIEW.REFRESH_DEPENDENT(failures, 'table_name','A','RBS002',FALSE,FALSE). What paramer do I need to supply in place of failures?.