Instance crashing on import

On import from 8.1.7 to 9.2.0.4 a instance (!) crashing at the analysis, for example of such piece of a code of our developers :

...

union all
select C.KODGR||C.KODPGR||C.KODTMC||C.PR||' '||'('||S.obozn||')' DET, C.CENA CEN, '60' CEX, '0' EIZ, to_number(to_char(C.DATAI,'yyyy')) GOD, 'A' PRIZNAK,
C.EDIZM, A.ID_IZD ID_IZD
from CENNIKTMC C, SPRTMC S, ARTICLE A
where s.KODGR(+)||s.KODPGR(+)||s.KODTMC(+)||s.PR(+) = C.KODGR||C.KODPGR||C.KODTMC||C.PR
and KODCEN = 1
and C.CENA is not null
and A.NOMENKL(+) = C.KODGR||C.KODPGR||C.KODTMC||C.PR group by C.KODGR||C.KODPGR||C.KODTMC||C.PR||' '||'('||obozn||')', C.CENA, C.EDIZM, to_number(to_char(C.DATAI,'yyyy')),A.ID_IZD
....

So can some one help me please ? Probably, problem in a design group by, but on another of an opportunity to construct it on our structures, as convince, is not present. Can, to try any _ parameter change? Has got it me - forces is not present... Compatible install to 8.1.7 , but the problem subsist...

Win 2000 AS Oracle 9.2.0.4 RAC (2 nodes)

With regards, Sergey Received on Wed Jan 28 2004 - 00:15:56 CST