ORA-01536:表領域「XX」の空間限度額を超えている
1002 ワード
ORA-01536:表空間'XX'の空間限度額を超えた【転載】
ORA-01536 ,
select * from dba_ts_quotas;
select * from user_ts_quotas;
max_bytes -1 , .
dba_ts_quotas :
user_ts_quotas : 。
max_bytes -1, 。
:
GRANT UNLIMITED TABLESPACE TOuser;
。
alter useruserquota unlimited onuser_tablespace;
.
:
revoke unlimited tablespace fromuser;
alter useruserquota 0 onuser_tablespace;
ORA-01536:space quota exceeded for table space ’ALCATEL’
, :
(1) alter user USERNAME quota 100M on TABLESPACENAME;
(2) alter user USERNAME quota unlimited on TABLESPACENAME;
(3) grant unlimited tablespace to USERNAME;
,
create user CSLMS
default tablespace CSLMS
temporary tablespace TEMP
profile DEFAULT;
grant connect to CSLMS with admin option;
grant resource to CSLMS with admin option;