Re: DBA_USERS: duplicated rows.

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Sun, 4 Jul 1999 01:11:11 -0400
Message-ID: <7lms0a$rfi$3@autumn.news.rcn.net>

Hi,

When you run the query to display the information from the view concatenate each column with leading and trailing special characters so you can see if there are any leading or trailing non-printing characters or spaces in the names. e.g;

SELECT '&'||owner||'&'||table_name||'&' FROM ....

regards
Jerry Gitomer

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.
>Oracle 8.0.5
>Digital UNIX 4.0d
>Digital Alpha Server 2100
>
>Thank you very much.
>
>Kekko
>
>
Received on Sun Jul 04 1999 - 00:11:11 CDT