| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_TS_QUOTAS describes tablespace quotas for all users.
USER_TS_QUOTAS describes tablespace quotas for the current user. This view does not display the USERNAME column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Tablespace name |
USERNAME |
VARCHAR2(30) |
NOT NULL |
User with resource rights on the tablespace |
BYTES |
NUMBER |
Number of bytes charged to the user | |
MAX_BYTES |
NUMBER |
User's quota in bytes, or -1 if no limit | |
BLOCKS |
NUMBER |
NOT NULL |
Number of Oracle blocks charged to the user |
MAX_BLOCKS |
NUMBER |
User's quota in Oracle blocks, or -1 if no limit |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
