Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBA_USERS: duplicated rows.

Re: DBA_USERS: duplicated rows.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 2 Jul 1999 08:54:14 +0100
Message-ID: <930902674.3265.0.nnrp-06.9e984b29@news.demon.co.uk>


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 Fri Jul 02 1999 - 02:54:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US