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"--.....
Pages
Home
Daily Essential Queries
R12.2 Quick Notes
DBA Shell Scripts
DBA SQL Queries
Interview Q & A
Contact Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment