Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Space Quota Exceeded for tablespace 'USERS'

 
jaya kemmannu
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Hi,

I have enough space in DB but still i get below Error in my application. What could be the reason ?


"ORA-01536 : space quota exceeded for tablespace 'USERS'

Regards,
Jay
 
Roger Sterling
Ranch Hand
Posts: 426
Eclipse IDE Fedora Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The problem is you exceeded the space quota for tablespace USERS.

Google is your friend.
 
jaya kemmannu
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi,

while executing below Query, Observed that USERS has 92% free space.

select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name
order by round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace));

SYSTEM 428 2 430 0
SYSAUX 267 43 310 14
USERS 25 300 325 92

Regards,
Jay
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic