SQL> desc dba_users;
Name Null? Type
----------------------------------------- -------- ----------------------------
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)
SQL> select username,default_tablespace,temporary_tablespace from dba_users;
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
OADBA
USERS
TEMP
OARBKDB
FIRSTFRAME_DATA
FIRSTFRAME_TEMP
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
RBKEAS
EAS_D_RBKEAS_STANDARD
EAS_T_RBKEAS_STANDARD
CESHI
EAS_D_CESHI_STANDARD
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
TEMP
OADB
EASOA_DATA
EASOA_TEMP
SYS
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
SYSTEM
TEMP
SYSTEM
SYSTEM
TEMP
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
MDSYS
SYSAUX
TEMP
ORDSYS
SYSAUX
TEMP
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
EXFSYS
SYSAUX
TEMP
DMSYS
SYSAUX
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
TEMP
DBSNMP
SYSAUX
TEMP
SCOTT
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
USERS
TEMP
WMSYS
SYSAUX
TEMP
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
ORACLE_OCM
USERS
TEMP
TSMSYS
USERS
TEMP
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
MDDATA
USERS
TEMP
CTXSYS
SYSAUX
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
TEMP
ANONYMOUS
SYSAUX
TEMP
OUTLN
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
SYSTEM
TEMP
DIP
USERS
TEMP
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
SYSMAN
SYSAUX
TEMP
XDB
SYSAUX
TEMP
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
ORDPLUGINS
SYSAUX
TEMP
MGMT_VIEW
SYSTEM
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
TEMP
SI_INFORMTN_SCHEMA
SYSAUX
TEMP
OLAPSYS
USERNAME
------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------------------------------------
TEMPORARY_TABLESPACE
------------------------------------------------------------
SYSAUX
TEMP
27 rows selected.
SQL>
评论