Oracle表空间，用户，表的总结代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】 Oracle表空间，用户，表的总结

作者:Dezai.CN / 发布于2011/7/21/ 1860

<div>
<span style="font-family: Verdana; font-size: 16px">一、表空间</span>
<span style="font-family: Verdana; font-size: 16px">查询所有表空间 select * from dba_tablespaces ;</span>


<span style="font-family: Verdana; font-size: 16px">二、用户</span>
<span style="font-family: Verdana; font-size: 16px">1.查询所有用户 select * from dba_users;</span>


<span style="font-family: Verdana; font-size: 16px">2.改变用户的表空间: </span>
<span style="font-family: Verdana; font-size: 16px">
ALTER USER "USERNAME " DEFAULT TABLESPACE "SPACEDATA " 
TEMPORARY TABLESPACE "SPACETEMP " 

USERNAME : 为用户名 
SPACEDATA: 为表空间 
SPACETEMP: 为临时表空间</span>
<span style="font-family: Verdana; font-size: 16px">三、表</span>
<span style="font-family: Verdana; font-size: 16px">查询所有表 select * from all_tables;</span>



<span style="font-family: Verdana; font-size: 16px">四、 Oracle查询所有函数和储存过程：</span>
<span style="font-family: Verdana; font-size: 16px">select * from user_source;</span>
<span style="font-family: Verdana; font-size: 16px">五、Oracle查看当前用户连接：</span>
<span style="font-family: Verdana; font-size: 16px">select * from v$Session;</span>
<span style="font-family: Verdana; font-size: 16px">六、Oracle查看当前用户权限：</span>
<span style="font-family: Verdana; font-size: 16px">select * from session_privs;</span>

</div>

试试其它关键字

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)