Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2005
    Posts
    108

    Unanswered: Refresh MVIEW problem

    I am using Oracle Database 10g Enterprise Edition Release 10.2.0.1 for Windows. When I use DBMS_MVIEW.REFRESH_ALL_MVIEWS to refresh materialized views. I got error:

    PHP Code:
    DECLARE FAILURES NUMBER;
    begin
    DBMS_MVIEW
    .REFRESH_ALL_MVIEWS(FAILURES'C'''TRUEFALSE);
    SYS.DBMS_OUTPUT.PUT_LINE('Failures: ' || to_char(FAILURES));
    END;
    /
     
    Line Pos Text 
    1 1 ORA
    -27486insufficient privileges
    ORA
    -06512at "SYS.DBMS_ISCHED"line 265
    ORA
    -06512at "SYS.DBMS_SCHEDULER"line 731
    ORA
    -06512at "SYS.DBMS_SNAPSHOT"line 1854
    ORA
    -27486insufficient privileges
    ORA
    -06512at "SYS.DBMS_SNAPSHOT"line 2255
    ORA
    -06512at "SYS.DBMS_SNAPSHOT"line 2955
    ORA
    -06512at line 3 
    But, if I change FALSE to TRUE in DBMS_MVIEW.REFRESH_ALL_MVIEWS(FAILURES, 'C', '', TRUE, FALSE), I don't receive any error.

    Why would atomic_refresh = FALSE need a special privilege? What kind of privilege is reuired? Can you please advise? Thank you in advance.
    Last edited by DBA-Jr; 10-03-09 at 16:47.

  2. #2
    Join Date
    Nov 2011
    Posts
    3

    Manage scheduler

    To fix this:
    grant MANAGE SCHEDULER to <user>;

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    WOW!
    I am impressed that you went to the trouble to register just to respond to a 3 year old thread.
    How many more zombie posts do you plan on resurrecting?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Nov 2011
    Posts
    3

    I did wonder

    Yes, and I had to register first. But I hit the same problem, and this was the only place it was posted, so I thought I'd put it there for posterity. Feel free to send cash.

  5. #5
    Join Date
    Mar 2012
    Posts
    1

    Thanks

    Quote Originally Posted by DuncanG View Post
    Yes, and I had to register first. But I hit the same problem, and this was the only place it was posted, so I thought I'd put it there for posterity. Feel free to send cash.
    I've found it!! Thanks. Well done, in spite of 3 years ago.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •