SQL & PL/SQL

Hi,

There's a materialized view created in 2006 as under:

CREATE MATERIALIZED VIEW "schema"."mv_name"
USING INDEX
REFRESH FAST ON DEMAND
WITH PRIMARY KEY USING DEFAULT LOCAL ROLLBACK SEGMENT
DISABLE QUERY REWRITE AS SELECT * FROM "table_name@dblink;

The problem is that the last refresh was done in Aug. I want to manually refresh this materialized view right now as there is a procedure based on this MV and its not showing the right data as the above materialized view has not been refreshed, so the data for this month is not showing.

Please let me know how I can refresh that MV right now.

Also do I need to change the refresh option. How can I change it so that the MV refreshes itself every second.

Thanks