Tablespace | 十字螺丝钉的DBA日记

Oracle查询用户有哪些表空间的写入权限(DBA_TS_QUOTAS)

通过Oracle视图 DBA_TS_QUOTAS，能获知Oracle用户拥有哪些表空间的读写权限（quota，也就是配额）。

SQL> select TABLESPACE_NAME,
       USERNAME,
       BYTES / 1024 / 1024 / 1024 AS G,
       MAX_BYTES,
       MAX_BLOCKS,
       DROPPED
  from dba_ts_quotas
 where USERNAME = 'BIUSER1';


TABLESPACE_NAME                USERNAME                                G  MAX_BYTES MAX_BLOCKS DRO
------------------------------ ------------------------------ ---------- ---------- ---------- ---
TS_BSC                         BIUSER1                         1419.81958         -1         -1 NO
TS_INX_BSC                     BIUSER1                         90.5799561         -1         -1 NO
TS_ORD                         BIUSER1                         484.465637         -1         -1 NO
TS_INX_ORD                     BIUSER1                         420.236389         -1         -1 NO
TS_FUL                         BIUSER1                         229.671753         -1         -1 NO
TS_INX_FUL                     BIUSER1                         .013305664         -1         -1 NO
FUL_TMP_TBS                    BIUSER1                         193.251648         -1         -1 NO

7 rows selected.

SQL> select TABLESPACE_NAME,

USERNAME,

BYTES / 1024 / 1024 / 1024 AS G,

MAX_BYTES,

MAX_BLOCKS,

DROPPED

from dba_ts_quotas

where USERNAME = 'BIUSER1';

TABLESPACE_NAME USERNAME G MAX_BYTES MAX_BLOCKS DRO

------------------------------ ------------------------------ ---------- ---------- ---------- ---

TS_BSC BIUSER1 1419.81958 -1 -1 NO

TS_INX_BSC BIUSER1 90.5799561 -1 -1 NO

TS_ORD BIUSER1 484.465637 -1 -1 NO

TS_INX_ORD BIUSER1 420.236389 -1 -1 NO

TS_FUL BIUSER1 229.671753 -1 -1 NO

TS_INX_FUL BIUSER1 .013305664 -1 -1 NO

FUL_TMP_TBS BIUSER1 193.251648 -1 -1 NO

7 rows selected.

DBA_TS_QUOTAS 描述了所有用户的tablespace配额情况。 Column Datatype NULL Description TABLESPACE_NAME VARCHAR2(3

一	二	三	四	五	六	日
« 9月
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31