SQL & PL/SQL

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!

Views Automatically invalidated

AnkitGoelMay 4 2010 — edited May 4 2010

Hi

I have created some force views in my database. Every morning when i check the invalid objects these views are automactically invalidated. When i compile them they get valid and again the next day they become invalid.

The view is a join of 2-3 tables and every night one of the tables is truncated, the indexes are dropped ,data inserted and indexes are recreated.

Any other ddl is not fired on any of the tables in the view.

The version of oracle :

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Regards
Ankit

This post has been answered by Saubhik Banerjee on May 4 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2010

Added on May 4 2010

2 comments

1,175 views