-
materialized view stopped refeshing
Oracle 10g on a windows box -- I have 5 or 6 materialized views and have noticed that one of these mv's have stopped being refeshed. Here is the error I'm receiving
BEGIN
DBMS_SNAPSHOT.REFRESH(
LIST => 'xxxxx.MV_xxxxxxxxxxxx'
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => FALSE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE
,NESTED => FALSE);
END;
Error at line 2
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2537
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2743
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2712
ORA-06512: at line 2
-
Do all base tables exist and are available? - See ORA-00942
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
The underlying query executes ok. This was the only MV that we were having a problem with. dropping a recreating the mv clears up the problem. Any clue to as why this would of been happening?
-
Originally Posted by Bogey
The underlying query executes ok. This was the only MV that we were having a problem with. dropping a recreating the mv clears up the problem. Any clue to as why this would of been happening?
If it happens again I would trace/tkprof the session so to have detailed information about what Oracle is complaining about.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|