Oracle 查看用户,表,表空间,字段
查看用户
select *
from dba_users
查看用户表
select *
from user_tables
查看字段
select *
from user_tab_columns
/* Formatted on 2012-01-20 오전 10:32:56 (QP5 v5.149.1003.31008) */
SELECT DISTINCT d.table_name, C.TABLESPACE_NAME ind_tbsp_name
FROM user_indexes
SELECT DISTINCT table_name,g.TABLESPACE_NAME par_ind_tbsp_name
FROM user_indexes f, USER_IND_PARTITIONS g
WHERE f.INDEX_NAME = g.INDEX_NAME;
SELECT a.table_name,
a.tablespace_name tbsp_name,
b.tablespace_name par_tbsp_name
FROM dba_tables a,
dba_TAB_PARTITIONS b
WHERE a.owner = ‘EDBADM’
AND a.table_name = b.table_name(+)
转载于//www.cnblogs.com/kevinkim/archive/2012/01/16/2323735.html
还没有评论,来说两句吧...