Re: 8.1.5 - Dual gone schizoid

In article <946563069.23198.0.nnrp-14.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> Has anyone encountered this before ?
> Oracle 8.1.5.0 on NT sp3:
>
> sqlplus sys/sys
> select count(*) from sys.dual;
>
> COUNT(*)
> ---------
> 2
>
> select sysdate from sys.dual;
>
> SYSDATE
> -------
> 30-DEC-99
>
> declare
> d date;
> begin
> select sysdate into d from sys.dual;
> end;
> .
> /
>
> ORA-01422: exact fetch returns more than requested number of rows
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
>

I intentially inserted a row into dual once to see what would happen and let just say it caused a ton of problems. Do a delete from dual and you should end up with one row. I discussed this with an oracle instructor who was doing a P&T class and I think he said the only way to correct it was a DB rebuild. He had seen it happen before and it had been an indication of a very corrupt DB rather than an insert to DUAL.

Lots of luck..............

--
Doug Coan
Senior Client Server System Integrator
Oracle Certified Professional DBA
AEGON USA
dcoan_at_aegonusa.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 30 1999 - 14:31:09 CST