We recently moved all the reports from primary database to standby database to reduce the primary db load.
Now one of the report is intermittently failing since, the report has materialize hint.
I read this in your website.
https://oracle-base.com/articles/mis ... clause.php
Code: Select all
Note. This is an undocumented feature. I've given you an example that uses a global temporary table, but perhaps there are other circumstances that don't.
I see your note... What other circumstance, this query does not create global temp table?
Please let me know if you have any input.