I’m new to Optimizer forums, so please forgive me if I´m asking already answered questions…
Trial Version 126.96.36.1993
I have a pretty big SQL code (a view) who performs badly… This code compiles and run without problems…
I paste it into the SQL Text panel and run the Rewrite and Index function. The results were 244 alternatives… So far, so good… The problem begins with the batch run process… Most of the alternatives passed, but the original code don´t, so no Resolution Summary can be generated until de original sql statement is executed… The error is:
ORA-00936: missing expression ORA-06512: at line 1291, but my code has only 450 lines (yes, there are functions).
Anybody knows how to debug and fix this problem?