-
Ora-4045: what could cause Materialized View to 'NEEDS_COMPILE'?
We got ora-4045 while running a query again a materialized view. It seems the Materialized View needs to be compiled.
According to Oracle: 'A materialized view is automatically revalidated when it is referenced'. We only had DML on the base tables.
So when the materialized views will be 'automatically revalidated' and when they will not and we get ora-4045?
Thanks!
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
|