Re: Instance crashing on import

"Sergey Kolesov" <SKolesov_at_vbf.ru> wrote in message news:<bv7k3l$1r2h$1_at_Bizone.inar.ru>...
> 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

Don't assume anyone in this group has a crystall ball. Don't assume anyone will try to reproduce your problem. Consequently if you don't want to disclose what 'crashing' means (like exact error messages etc), ie if you don't want to do minimal work yourself, do not post here, but submit an iTar. *They* are paid for it, *we* aren't.

Sybrand Bakker
Senior Oracle DBA Received on Wed Jan 28 2004 - 05:03:25 CST