dba_users

SQL> desc dba_users
名前 NULL? 型
-------------------------------------------------------------------------------

USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)
PASSWORD_VERSIONS VARCHAR2(8)
EDITIONS_ENABLED VARCHAR2(1)

SQL> set line 300
SQL> set pagesize 100
SQL> select username,default_tablespace from dba_users;

USERNAME DEFAULT_TABLESPACE

• • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • -

MGMT_VIEW SYSTEM
SYS SYSTEM
SYSTEM SYSTEM
DBSNMP SYSAUX
SYSMAN SYSAUX
OUTLN SYSTEM
FLOWS_FILES SYSAUX
MDSYS SYSAUX
ORDSYS SYSAUX
EXFSYS SYSAUX
WMSYS SYSAUX
WKSYS SYSAUX
WK_TEST SYSAUX
CTXSYS SYSAUX
ANONYMOUS SYSAUX
XDB SYSAUX
WKPROXY SYSAUX
ORDPLUGINS SYSAUX
FLOWS_030000 SYSAUX
OWBSYS SYSAUX
SI_INFORMTN_SCHEMA SYSAUX
OLAPSYS SYSAUX
SCOTT USERS
ORACLE_OCM USERS
TSMSYS USERS
XS$NULL USERS
BI USERS
PM USERS
MDDATA USERS
IX USERS
SH USERS
DIP USERS
OE USERS
APEX_PUBLIC_USER USERS
HR USERS
.
.
.