Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: Mview refresh error

    Can someone please help me with this-
    I'm refreshing an mview and I get the below error. The mview exists in the schema and I can select it too but when I Refresh it, I get an error. Any idea?

    Error starting at line 1 in command:
    exec dbms_mview.refresh('sample_mv');
    Error report:
    ORA-00942: table or view does not exist
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429
    ORA-06512: at line 1

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Privs acquired via ROLE to NOT apply within PL/SQL procedures!
    Explicit GRANTs must be issued to invoking user.
    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.

  3. #3
    Join Date
    Jul 2005
    Posts
    276
    My other team member created the Mview and I was able to refresh them in the last week but I get an error now.

    We both log into the same schema with the same user/pwd.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >My other team member created the Mview and I was able to refresh them in the last week but I get an error now.
    So what changed? & change it back to as it was when it worked.
    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.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Check the query that is used in the refresh. Either the original table referenced in the query is no longer there or it is in a different schema and you do not have access.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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