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: Kekko <dini.f_at_adr.it>
Date: Thu, 08 Jul 1999 18:02:49 +0200
Message-ID: <3784CBA8.6A30C66C@adr.it>


I would know if I can execute newly SQL.BSQ ?

Jerry Gitomer wrote:

> 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 Thu Jul 08 1999 - 11:02:49 CDT

Original text of this message

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