17.Oracle杂记——数据字典dba_ts_quotas

17.Oracle杂记——数据字典dba_ts_quotas

视图dba_ts_quotas:所有用户表空间限额     

描述如下：

sys@PDB1> desc dba_ts_quotas

 Name                                                                                                     Null?         Type

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

 TABLESPACE_NAME                                                                        NOT NULL VARCHAR2(30)

 USERNAME                                                                                         NOT NULL VARCHAR2(128)

 BYTES                                                                                                                                 NUMBER

 MAX_BYTES                                                                                                                     NUMBER

 BLOCKS                                                                                                                             NUMBER

 MAX_BLOCKS                                                                                                                  NUMBER

 DROPPED                                                                                                                          VARCHAR2(3)

各个列描述如下：

TABLESPACE_NAME：表空间名字

 USERNAME：拥有资源权限的用户

 BYTES：用户拥有的字节数

 MAX_BYTES：用户的配额（字节），-1表示无限制

 BLOCKS：用户负责的块数量

 MAX_BLOCKS：用户的配额（块），-1表示无限制

 DROPPED：表是否被drop了。