"Bliss" <bliss_is_ignorance_at_hotmail.com> wrote in message
news:3f0f90bf_2_at_news.tm.net.my...
> Thanks Niall.
>
> > I don't believe this to be true (at least in 9i). At least it ought not
to
> > be true ISTM that the results described are just wrong and if repeatable
> are
> > a bug. See demo below (9.0.1). If the OP can reproduce I suggest logging
a
> > TAR.
> Yes it is repeatable. I was trying to figure out what was happening for
> quiet some time before posting this and it happened every time (and still
is
> happening).
>
> > IIRC there were some problems with concatenated indexes and NULLs around
> > 8.1.5. The actual version might help.
> Yes it's 8.1.5
>
> Regards,
> Bliss
I'd definitely try raising a TAR with Oracle then. That said some digging
around produces bug 924671 which *could* be related and is fixed in 8.1.6.
It probably doesn't help you much but 8.1.7.4 is the currently supported 8i
release and an upgrade might well be the suggested solution.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sat Jul 12 2003 - 10:14:00 CDT
