Re: DBA_USERS: duplicated rows.

From: Kekko <dini.f_at_adr.it>
Date: Mon, 12 Jul 1999 08:57:03 +0200
Message-ID: <378991BF.A017A019@adr.it>

Thank you but it wasn't the fact:

SQLWKS> select username, dump(username) from dba_users;

USERNAME                       DUMP(USERNAME)
------------------------------ ---------------------------------
SYS                            Typ=1 Len=3: 83,89,83
SYSTEM                         Typ=1 Len=6: 83,89,83,84,69,77
CED                            Typ=1 Len=3: 67,69,68
REPO                           Typ=1 Len=4: 82,69,80,79
DBSNMP                         Typ=1 Len=6: 68,66,83,78,77,80
CED1                           Typ=1 Len=4: 67,69,68,49
SYS                            Typ=1 Len=3: 83,89,83
SYSTEM                         Typ=1 Len=6: 83,89,83,84,69,77
CED                            Typ=1 Len=3: 67,69,68
REPO                           Typ=1 Len=4: 82,69,80,79
DBSNMP                         Typ=1 Len=6: 68,66,83,78,77,80
CED1                           Typ=1 Len=4: 67,69,68,49

12 rows selected.

Jonathan Lewis wrote:

> Did this fix the problem, or are the duplicates still there ?
> Is it possible that you have users with space padded names ?
>
> Try
> select username, dump(username) from dba_users;
> to check this.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Kekko wrote in message <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.
Received on Mon Jul 12 1999 - 01:57:03 CDT