Way to success...

--"Running Away From Any PROBLEM Only Increases The DISTANCE From The SOLUTION"--.....--"Your Thoughts Create Your FUTURE"--.....--"EXCELLENCE is not ACT but a HABIT"--.....--"EXPECT nothing and APPRECIATE everything"--.....

Wednesday, June 21, 2017

ORA-01536: space quota exceeded for tablespace 'TABLESPACE_NAME'


Issue:

ERROR at line 1:
ORA-01536: space quota exceeded for tablespace 'USERS'


Solution:

alter user to have unlimited quota on tablespace

connect /as sysdba

USER is "SYS"

SQL> alter user USERNAME quota unlimited on TABLESPACE_NAME;

User altered.


No comments:

Post a Comment