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
- --------------------------------
0 OPEN
1 EXPIRED
2 EXPIRED(GRACE)
4 LOCKED(TIMED)
8 LOCKED
5 EXPIRED & LOCKED(TIMED)
6 EXPIRED(GRACE) & LOCKED(TIMED)
9 EXPIRED & LOCKED
10 EXPIRED(GRACE) & LOCKED
0 OPEN
1 EXPIRED
2 EXPIRED(GRACE)
4 LOCKED(TIMED)
8 LOCKED
5 EXPIRED (TIMED)
6 EXPIRED(GRACE) (TIMED)
9 EXPIRED
10 EXPIRED(GRACE)
18 rows selected.
And this is the problem:
SQLWKS> select =
username,user_id,account_status,default_tablespace,temporary_tablespace,c=
reated from dba_users;
USERNAME USER_ID ACCOUNT_STATUS DEFAULT_TABLESP =
TEMPORARY_TABLE CREATED
- ---------- --------------- --------------- =
--------------- --------------------
SYS 0 OPEN SYSTEM TEMP =
16-APR-99
SYSTEM 5 OPEN TOOLS TEMP =
16-APR-99
CED 21 OPEN CED00001_TSD TEMP =
16-APR-99
REPO 23 OPEN ENTE0001_TSD TEMP =
16-APR-99
SYSCASE 51 OPEN DES2 TEMP =
05-JUL-99
CASE001 27 OPEN DES2 TEMP =
19-APR-99
CASE002 28 OPEN DES2 TEMP =
19-APR-99
CED1 29 OPEN CED00001_TSD TEMP =
28-APR-99
DBSNMP 45 OPEN SYSTEM SYSTEM =
03-JUN-99
SYS 0 OPEN SYSTEM TEMP =
16-APR-99
SYSTEM 5 OPEN TOOLS TEMP =
16-APR-99
CED 21 OPEN CED00001_TSD TEMP =
16-APR-99
REPO 23 OPEN ENTE0001_TSD TEMP =
16-APR-99
SYSCASE 51 OPEN DES2 TEMP =
05-JUL-99
CASE001 27 OPEN DES2 TEMP =
19-APR-99
CASE002 28 OPEN DES2 TEMP =
19-APR-99
CED1 29 OPEN CED00001_TSD TEMP =
28-APR-99
DBSNMP 45 OPEN SYSTEM SYSTEM =
03-JUN-99
18 rows selected.
Received on Thu Jul 08 1999 - 13:13:28 CDT