Re: DBA_USERS: duplicated rows.

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Fri, 2 Jul 1999 11:42:04 -0300
Message-ID: <Y15f3.414$jl.10453509@newscontent-01.sprint.ca>

check where is dulplication in tables:

sys.user$, sys.user_astatus_map, sys.profname$, sys.profile$

Regards,
Mark

Kekko <dini.f_at_adr.it> wrote in message news:377C6C5D.BA364B25_at_adr.it...
> I still continue to have a problem with the dba_users view: it has
> duplicated rows. I recreated it but the problem isn't resolved. Than I
> modified the creaption script in the catalog.sql: I specified the select
> distinct.
> Oracle 8.0.5
> Digital UNIX 4.0d
> Digital Alpha Server 2100
>
> Thank you very much.
>
> Kekko
>
>
Received on Fri Jul 02 1999 - 09:42:04 CDT