Re: possible dual table problem

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Wed, 17 Jun 1998 00:37:19 GMT
Message-ID: <6m733m$qt@bgtnsc03.worldnet.att.net>

You need to either recreate the DUAL table, or delete one of the rows. Strange that two rows got in there in the first place. DUAL is owned by SYS, so log on as SYS and try somethnig like the following:

SQL> describe dual

 Name                            Null?    Type
 ------------------------------- -------- ----
 DUMMY                                    VARCHAR2(1)

SQL> select dummy,rowid from dual;

D ROWID

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

X AAAAeGAABAAAATmAAA

SQL> delete from dual where rowid='AAAAeGAABAAAATmAAA';

1 row deleted.

Don't forget to do a commit.

On 16 Jun 1998 15:41:07 -0700, David Doll <djd_at_saul10.u.washington.edu> wrote:

>then I tried select * from dual and got:
>
>D
>--
>X
>X
>
>I'm guessing something is wrong. Can anyone enlighten me as to what is going
>on and or how to fix it. What litte in the way of docs I have was of no help...
>Thanks for your time and help
Received on Tue Jun 16 1998 - 19:37:19 CDT