SQL> exec dbms_mview.REFRESH_ALL_MVIEWS;
BEGIN dbms_mview.REFRESH_ALL_MVIEWS; END; *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'REFRESH_ALL_MVIEWS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored我要刷我库里的所有物化视图 这个问题究竟是什么? 求解求答案SQL> exec dbms_mview.refresh_dependent('EMP');
BEGIN dbms_mview.refresh_dependent('EMP'); END; *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'REFRESH_DEPENDENT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored我要刷新 某个特定表相关的所有物化视图 这个也是一样的问题。。求解答
BEGIN dbms_mview.REFRESH_ALL_MVIEWS; END; *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'REFRESH_ALL_MVIEWS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored我要刷我库里的所有物化视图 这个问题究竟是什么? 求解求答案SQL> exec dbms_mview.refresh_dependent('EMP');
BEGIN dbms_mview.refresh_dependent('EMP'); END; *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'REFRESH_DEPENDENT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored我要刷新 某个特定表相关的所有物化视图 这个也是一样的问题。。求解答
如下:
declare
out_err number;
begin
dbms_mview.refresh_dependent(number_of_failures => out_err,
list => 'EMP',
method => 'f',
refresh_after_errors => true,
atomic_refresh => false);
dbms_output.put_line(out_err);
end;'EMP'为表名
declare
out_err number;
begin
dbms_mview.refresh_dependent(number_of_failures => out_err,
list => 'EMP',
method => 'C',
refresh_after_errors => true,
atomic_refresh => false);
dbms_output.put_line(out_err);
end;
nnn binary_integer;
begin
dbms_mview.refresh_all_mviews(nnn);
end;它是带参的。这和物化视图没太大关系,就是一个调用带参的存储过程的代码