Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query dba_users table

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 -------------------- -------------- ---------- - RNTSOFT               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> --