Hi folks,

there is always error ORA 1986 when I try to execute "alter session set optimizer_goal = all_rows".

invalid option for OPTIMIZER_GOAL

So in 8.1.7 and 9.2.0 it works just fine.

What do I have to do to make it work in 10g or especially 10g XE?

Thanks for helping!