|
SQL>
SQL> set define off
SQL> set echo off
SQL> set linesize 78
SQL>
SQL> prompt User Information
User Information
SQL>
SQL> column username format a20 heading "Username"
SQL> column default_tablespace format a14 heading "Default Tblspc"
SQL> column temporary_tablespace format a10 heading "Temp Tblspc"
SQL> column locked format a1 heading "L"
SQL>
SQL> break on tblspc skip 1
SQL>
SQL> select username, default_tablespace, temporary_tablespace,
2 decode( account_status, 'EXPIRED & LOCKED', '*',
3 'OPEN', '' ) locked
4 from dba_users
5 where rownum < 50
6 /
Username Default Tblspc Temp Tblsp L
-------------------- -------------- ---------- -
JAVA2S SYSTEM TEMP
SYS SYSTEM TEMP
SYSTEM SYSTEM TEMP
ANONYMOUS SYSAUX TEMP
MDSYS SYSTEM TEMP *
OUTLN SYSTEM TEMP *
DIP SYSTEM TEMP *
TSMSYS SYSTEM TEMP *
FLOWS_FILES SYSAUX TEMP *
CTXSYS SYSAUX TEMP *
DBSNMP SYSAUX TEMP *
FLOWS_020100 SYSAUX TEMP *
XDB SYSAUX TEMP *
HR USERS TEMP *
14 rows selected.
SQL> set define on
SQL>
SQL>
SQL> --
|