Bom dia pessoal.
Estou usando o oracle 11.2.0.4.0 quando eu executo o tunning advisor esta aparecendo o erro abaixo:
ORA-02014: não é possível selecionar FOR UPDATE a partir da view com DISTINCT, GROUP BY etc.
ORA-06512: em “SYS.PRVT_ADVISOR”, line 2738
ORA-06512: em “SYS.DBMS_ADVISOR”, line 241
ORA-06512: em “SYS.DBMS_SQLTUNE”, line 837
ORA-06512: em line 1
02014. 00000 – “cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.”
*Cause: An attempt was made to select FOR UPDATE from a view which
had not been merged because the view used syntax (for example,
DISTINCT or GROUP BY) preventing the merge, or because of
initialization file parameter settings.
*Action: Determine the reason the view will not merge and, if possible,
make changes so that it can.
>>Query Run In:Resultado da Consulta
>>Query Run In:Resultado da Consulta 1
José Laurindo Chiappa.
José Laurindo Chiappa.
Carlos Cesar Costa Oliveira
Carlos Cesar Costa Oliveira
José Laurindo Chiappa