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 Oracle 8.0.5 for Digital UNIX

Re: DBA_USERS Oracle 8.0.5 for Digital UNIX

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 8 Jul 1999 19:13:28 +0100
Message-ID: <931457923.6064.1.nnrp-10.9e984b29@news.demon.co.uk>


Looks as if your user_astatus_map
has got two copies of every status code, so the join will always double up your users.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

    Kekko wrote in message <3784DAA2.1D1B98BF_at_adr.it>...     SQLWKS> select * from user_astatus_map;     STATUS# STATUS

Received on Thu Jul 08 1999 - 13:13:28 CDT

Original text of this message

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