2014/07/11

Materialize subquery on Active DataGuard

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.

No comments: