Re: 8.1.5 - Dual gone schizoid

It is true that there is an X$DUAL in 8.1.5, furthermore you can 'select * from dual' after doing just STARTUP NOMOUNT and
Oracle will return the contents of X$DUAL rather than the usual 'database not available' error.

It would be very nice if Oracle Corp actually took this route, and eliminated managed to eliminate the risk of applications going wrong because extra rows have got into a real DUAL.

So it is possible that the problem is transitional, but I hope Fred Petillot's comment

> This should be documented Real Soon Now. It was logged as
> a bug (762093), then dismissed as proper behaviour.

doesn't mean what it seems to mean. I can't think of any good reason why

    select count(*) from objectX
and

    select * from objectX one row at a time should allow me to produce different results, even for the special case of DUAL (the real table).

(Of course the special case of SQL being executed by SYS behaving differently from any other account is okay ;) ).

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <3870789F.2483_at_yahoo.com>...
>I heard runours a while ago that DUAL was going to be a (for lack of a
>better term) "virtual" table as of 8.1.5 - ie some special internals
>rather than a 'genuine' table for performance reasons...Could this be a
>possible explanation ?
Received on Mon Jan 03 2000 - 12:49:08 CST