SV: Re: Re: Select from dual return 3 rows !

From: Frank B Hansen <frank4oraclel_at_yahoo.dk>
Date: Tue, 8 Nov 2005 13:07:32 +0100 (CET)
Message-ID: <20051108120732.19414.qmail@web86904.mail.ukl.yahoo.com>

Hi Raj

That was the issue !

system_at_HCRD9397> select object_name , object_type, owner from dba_objects where object_name like '%DUAL%';

OBJECT_NAME                    OBJECT_TYPE        OWNER


------------------------------ ------------------ ------------------------------

DUAL                           TABLE              SYS
DUAL                           SYNONYM            PUBLIC
DUAL                           TABLE              SYSTEM

system_at_HCRD9397> drop table system.dual; Table dropped.

system_at_HCRD9397> select object_name , object_type, owner from dba_objects where object_name like '%DUAL%';

OBJECT_NAME                    OBJECT_TYPE        OWNER


------------------------------ ------------------ ------------------------------

DUAL                           TABLE              SYS
DUAL                           SYNONYM            PUBLIC

system_at_HCRD9397> select * from dual;
D
-

X

I will now try to hunt down the ones responsible and kill them slowly !

Thanks, Frank

rjamya <rjamya_at_gmail.com> skrev:
probably system owns a table called dual ... check that first.

Raj

On 11/8/05, Frank B Hansen <frank4oraclel_at_yahoo.dk > wrote:Hi David

OK. Next question and some additional info:

It is only when connected as SYSTEM that 3 rows are returned. If I connect as SYS og SCOTT, only 1 row is returned.

A select from x$dual returns one row:

sys_at_HCRD9397> select * from x$dual;
ADDR INDX INST_ID D
-------- ---------- ---------- -

01B74DC8 0 1 X

and the question:
How do I delete row number the second and third row from dual ?

Thanks,
Frank

David Sharples <davidsharples_at_gmail.com> skrev: someone inserted 2 extra rows into dual, find them and tell them politely not to do it again. Then delete the other rows as you have a broken database right now

On 11/8/05, Frank B Hansen <frank4oraclel_at_yahoo.dk > wrote: No matter what I select from dual, I get 3 rows. Anyone seen this behaviour ?

This space is available for rent.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 08 2005 - 06:09:37 CST