ORA-01536: space quota exceeded for tablespace '

最新推荐文章于 2022-03-08 17:20:01 发布

EVISWANG

最新推荐文章于 2022-03-08 17:20:01 发布

阅读量604

点赞数

分类专栏： Tablespace 文章标签： ORA-01536

本文链接：https://blog.csdn.net/EVISWANG/article/details/84951872

版权

Tablespace 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

SQL> create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLICY_ID))
tablespace FQZDATATBS ;
2 create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLICY_ID))
*
ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'FQZDATATBS'

SQL> select * from dba_ts_quotas where TABLESPACE_NAME='FQZDATATBS';

TABLESPACE_NAME USERNAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS DRO
------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---
FQZDATATBS FQZCOG 4259840 -1 520 -1 NO
FQZDATATBS FQZBUSI 2.9488E+10 -1 3599600 -1 NO

SQL> SELECT USERNAME,DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'FQZBUSI';

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
FQZBUSI FQZDATATBS

SQL> SELECT USERNAME,DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'FQZRULE';

USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
FQZRULE FQZDATATBS

SQL> alter user FQZRULE quota unlimited on FQZDATATBS;

User altered.

SQL> select * from dba_ts_quotas where TABLESPACE_NAME='FQZDATATBS';

TABLESPACE_NAME USERNAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS DRO
------------------------------ ------------------------------ ---------- ---------- ---------- ---------- ---
FQZDATATBS FQZRULE 5483921408 -1 669424 -1 NO
FQZDATATBS FQZCOG 4259840 -1 520 -1 NO
FQZDATATBS FQZBUSI 2.9488E+10 -1 3599600 -1 NO

SQL>
SQL> create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLICY_ID))
tablespace FQZDATATBS ;
2

Index created.

SQL> SQL>
SQL> drop index fqzrule.PK_DD_POLICY122T;

Index dropped.

SQL>