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!

Materialized View ORA-08103: object no longer exists

604207Sep 11 2008 — edited Sep 11 2008

I have a materialized view which gets refreshed(COMPLETE Refresh) every 2 minutes. However there are few scheduled programs which queries this materialized view, some of the queries in the scheduled program take longer to run. When the materialized view refresh time overlaps with this query executing from the program i get this error: ORA-08103: object no longer exists.

I know that COMPLETE refresh doing TRUNCATE + INSERT is causing the issue, could someone suggest a workaround for this. But i need to do a COMPLETE refresh.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2008

Added on Sep 11 2008

#error, #general-database-discussions, #refresh

3 comments

1,204 views