Re: Dual - multiple rows

A copy of this was sent to Kekko <dini.f_at_adr.it> (if that email address didn't require changing) On Fri, 03 Sep 1999 15:29:58 +0200, you wrote:

>I had the same problem with this query:
>SELECT USER FROM DUAL;
>but the problem was in the dba_users view that contained all rows duplicated.
>I wrote also to Oracle and it said that likely some index was corrupted.
>This problem is known but it's not yet resolved.
>I had to rebuild the db.
>This was on Oracle 8.0.5 on Digital UNX 4.0d.
>Kekko
>

i am thoroughly confused on that one:

select USER from dual

does not touch dba_users. the status of dba_users has ZERO impact on dual.   

dual has no indexes at all on it.

What was the problem you had with the query?

>
>Thomas Kyte wrote:
>
>> A copy of this was sent to g.renfrew_at_acca.org.uk
>> (if that email address didn't require changing)
>> On Thu, 02 Sep 1999 10:11:43 GMT, you wrote:
>>
>> >Hi everyone,
>> >
>> >I'm running 7.3.2.3 on Solaris 2.6 and came across a bit of a weird
>> >problem with the DUAL table. When I selected from DUAL it always
>> >returned two identical rows. On all my other databases I would only
>> >ever expect one row returned, as is normal. This problem caused a
>> >couple of errors with "ora-1422: exact fetch returns more than
>> >requested number of rows". When I did "select * from dual" it returned
>> >the following:
>> >DUMMY
>> >-----
>> >X
>> >x
>> >
>> >Since all my other databases returned only 'X' I deleted from dual
>> >where DUMMY = 'x' and everything is ok now.
>> >Any ideas on how an extra row would appear in DUAL?
>> >
>>
>> somebody inserted it (one of your DBAs probably).
>>
>> DUAL is a real table -- its not special or anything. If it has no rows --
>> that'll cause havoc. If it has >1 row, same thing.
>>
>> >Best Regards
>> >Graeme Renfrew
>> >DBA
>> >ACCA
>> >Glasgow
>> >
>> >
>> >Sent via Deja.com http://www.deja.com/
>> >Share what you know. Learn what you don't.
>>
>> --
>> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
>> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>>
>> Thomas Kyte tkyte_at_us.oracle.com
>> Oracle Service Industries Reston, VA USA
>>
>> Opinions are mine and do not necessarily reflect those of Oracle Corporation

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Sep 03 1999 - 08:47:19 CDT