Oracle查询用户有哪些表空间的写入权限(DBA_TS_QUOTAS)
2,669 total views, 1 views today
通过Oracle视图 DBA_TS_QUOTAS，能获知Oracle用户拥有哪些表空间的读写权限（quota，也就是配额）。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
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(30) |
NOT NULL |
Tablespace name |
USERNAME |
VARCHAR2(128) |
NOT NULL |
User with resource rights on the tablespace |
BYTES |
NUMBER |
Number of bytes charged to the user
用户占用的tablespace空间，单位bytes。 |
|
MAX_BYTES |
NUMBER |
User’s quota in bytes, or -1 if no limit
用户配额，-1表示没有限制。 |
|
BLOCKS |
NUMBER |
Number of Oracle blocks charged to the user | |
MAX_BLOCKS |
NUMBER |
User’s quota in Oracle blocks, or -1 if no limit
用户配额，-1表示没有限制。 |
|
DROPPED |
VARCHAR2(3) |
Whether the tablespace has been dropped
表空间是否删除。 |