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>