注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

欢迎光临我的博客

 
 
 

日志

 
 

查看数据库用户默认的表空间和临时表空间  

2013-05-30 19:28:59|  分类: 数据库 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

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>

  评论这张
 
阅读(733)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017