update materalized view

[mikedaruke]

Can I update the materalized view from an SQL worksheet?

I try execute DBMS_REFRESH.REFRESH('TEST');

But get ora-000900 error.

How can I do it threw the SQL worksheet?

 

[sem]

Try

begin
  DBMS_REFRESH.REFRESH('TEST');
end;

Regards, Dima

http://seminihin.narod.ru