Hi all,
I'm having this query which is modified recently by using materialize hints. It runs fine when i run it manually but it doesn't when it gets triggered from dbms_scheduler job. In addition, it(if i run through dbms_scheduler) ignores only materialize hint(i have other hints in the query those are not affected). The strange thing is "With clause" instance is being referenced multiple places in the query so oracle should create temporary segment by default but it's not. Any suggestions would be appreciated.