Re: mv refresh question

From: Sidney Chen <huanshengchen@xxxxxxxxx>
To: JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx
Date: Fri, 28 Oct 2011 00:25:01 +0800

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

References:

help understanding an ORA-01732 error with inline view
From: Adric Norris

Re: help understanding an ORA-01732 error with inline view
From: Sidney Chen

Re: help understanding an ORA-01732 error with inline view
From: Adric Norris

Re: help understanding an ORA-01732 error with inline view
From: Sidney Chen

Re: help understanding an ORA-01732 error with inline view
From: Adric Norris

mv refresh question
From: Sheehan, Jeremy

Re: mv refresh question
From: Sidney Chen

Re: mv refresh question

Other related posts: