Re: double users in oracle8

After the "delete from dual where rownum = 1;" i have just one X in the dual table but the users are still double. If I i try to delete one of the double users in the OEM both are deleted ! ???
PLEASE HELP !
thanks Thorsten

In article <EDfiN1FFMaKlSB6q=rmLKPIsvJIJ_at_4ax.com>,   tkyte_at_us.oracle.com wrote:
> A copy of this was sent to thorsten2103_at_my-deja.com
> (if that email address didn't require changing)
> On Fri, 17 Sep 1999 12:13:57 GMT, you wrote:
>
> >after the installation of oracle8 and the "create database" order
> >the oracle user like "sys" and "system" are show double in the OEM.
> >A "select * from dual" return two "X" at this file.
> >Please help !
> >
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
> log in as sys.
>
> delete from dual where rownum = 1;
>
> You have 2 rows in DUAL which is deadly. get rid of one of them.
>
> --
> 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
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Sep 18 1999 - 09:24:16 CDT