DBA_TS_QUOTAS 表領域割り当て制限一覧

表領域割り当て制限一覧

表領域割り当て制限一覧SQL

SELECT TABLESPACE_NAME,USERNAME,BYTES,MAX_BYTES,BLOCKS,MAX_BLOCKS,DROPPED

FROM DBA_TS_QUOTAS order by USERNAME,TABLESPACE_NAME

;

SELECT TABLESPACE_NAME,USERNAME,BYTES,MAX_BYTES,BLOCKS,MAX_BLOCKS,DROPPED FROM DBA_TS_QUOTAS order by USERNAME,TABLESPACE_NAME ;

SELECT TABLESPACE_NAME,USERNAME,BYTES,MAX_BYTES,BLOCKS,MAX_BLOCKS,DROPPED
FROM DBA_TS_QUOTAS order by USERNAME,TABLESPACE_NAME
;

SQL実行例

TABLESPACE_NAME  USERNAME                  BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS DROPPED
---------------- -------------------- ---------- ---------- ---------- ---------- -------
SYSAUX           APPQOSSYS                     0         -1          0         -1 NO
SYSAUX           AUDSYS                  2031616         -1        248         -1 NO
SYSAUX           FLOWS_FILES                   0         -1          0         -1 NO
SYSAUX           GSMADMIN_INTERNAL       1441792  104857600        176      12800 NO
SYSAUX           OLAPSYS                       0         -1          0         -1 NO
TBS01            PFCHECKER                 65536         -1          8         -1 NO
TBS01            RENT_DBA               63963136         -1       7808         -1 NO
TBS01            SOONI                7226654720         -1     882160         -1 NO

8行が選択されました。

SQL>

SQL*Plus表示用

set lin 300

set pages 100

COLUMN TABLESPACE_NAME FORMAT A16

COLUMN USERNAME FORMAT A20

COLUMN DROPPED FORMAT A7

set lin 300 set pages 100 COLUMN TABLESPACE_NAME FORMAT A16 COLUMN USERNAME FORMAT A20 COLUMN DROPPED FORMAT A7

set lin 300
set pages 100
COLUMN TABLESPACE_NAME  FORMAT A16
COLUMN USERNAME FORMAT A20
COLUMN DROPPED   FORMAT A7

対象の表領域に対し使用量（クオータ）の割り当てを行う

表領域割り当てを無制限にするSQL

alter user dabada quota UNLIMITED on tbs01

;

alter user dabada quota UNLIMITED on tbs01 ;

alter user dabada quota UNLIMITED on tbs01
;

表領域割り当てを制限する（使えなくする）SQL