Re: double users in oracle8

Check the table

    sys.user_astatus_map
you may find that the entries in that table have all been duplicated.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

thorsten2103_at_my-deja.com wrote in message <7s2q1n$njg$1_at_nnrp1.deja.com>...
>Yes, I COMMIT my delete from dual but the result was the same.
>Now I have installed AIX 4.3.2 (on RS6000 43P-140) and ORACLE 8.0.5
>new on the system.
>And after the CREATE DATABASE-script I have just one "X"
>(great!) in the DUAL table but the users (system, sys and dbms)
>are still double on the left side in the security-manager. ???
>
>Please help !
>
>thanks
>Thorsten
>*******************************************************************
>
>In article <37e5e45a.3281483_at_news.siol.net>,
> jmodic_at_src.si (Jurij Modic) wrote:
>> On Sat, 18 Sep 1999 14:24:16 GMT, thorsten2103_at_my-deja.com wrote:
>>
>> >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
>>
>> Did you COMMIT your delete from dual?
>>
>> HTH,
>>
>> Jurij Modic <jmodic_at_src.si>
>> Certified Oracle DBA (7.3 & 8.0 OCP)
>> ================================================
>> The above opinions are mine and do not represent
>> any official standpoints of my employer
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sun Sep 19 1999 - 09:42:31 CDT