Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MVs getting compilation_error

user517698May 13 2008 — edited Jul 19 2010

Hi ,

I am using Oracle 10G and one of my MV is having this compile_state "compilation_error" and it's part of a refresh_group which i tried a manual refresh and it looks ok.

I have tried to recompile but it still having the "Compilation_error" compile state without any ORA-error

pls advise

tks & rgds

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2010

Added on May 13 2008

#general-database-discussions, #query

10 comments

22,581 views