Due to some bug Oracle can fail to materialize subquery from with ... as clause on Active DataGuard with error
ORA-00604: error occurred at recursive SQL level 2
ORA-16000: database open for read-only access
If subquery does not have materialize hint, the situation can be fixed by setting "_with_subquery"=INLINE on session or system level.
Please consult Oracle Support before using this on production system.
ORA-00604: error occurred at recursive SQL level 2
ORA-16000: database open for read-only access
If subquery does not have materialize hint, the situation can be fixed by setting "_with_subquery"=INLINE on session or system level.
Please consult Oracle Support before using this on production system.
No comments:
Post a Comment