Re: mv refresh question

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Fri, 28 Oct 2011 00:25:01 +0800
Message-ID: <CAM_ddu9Wb0GcX7MmuBNkh38V_FxsYS1GTFreEWQx1ntRT5SeUw_at_mail.gmail.com>

I cut from one refresh package, HTH

create or replace procedure my_mv_refresh is

l_code          number;
l_errm          varchar2(4000);
l_mv_name       varchar2(100) := 't_mv';
begin
        --proceed complete refresh
        dbms_mview.refresh(list=>l_mv_name, method=>'c',
atomic_refresh=>false);
        dbms_output.put_line('done successfully') ;
exception
        when others then
        l_code := sqlcode;
        l_errm := sqlerrm;
        dbms_output.put_line(l_code || ': ' || l_errm) ;
        commit;

end;
/
grant execute on my_mv_refresh to user1;

-- 
Regards
Sidney Chen


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 27 2011 - 11:25:01 CDT