ORA -12953: The request exceed the maximum allowed database size of 11GB

Admin 1
Viewed 21023

We have oracle express edition 11g i.e. ORACLE XE 64bit. There is 10GB available space in the database. But system tablespace is 98% full, there are 2 system tabalespaces. When we (our startup team) try to ADD or RESIZE the datafile or tablespace using ALTER command we get following error:

ORA -12953: The request exceed the maximum allowed database size of 11GB

What should be done to add or resize the datafile?

error

database-administration oracle11g oracle
2 Answers

As krokodilko says, it's a license limit.

Try to find some garbage or old data to delete... maybe some log table or something like that!

select owner||'.'||segment_name,segment_type, trunc(sum(bytes/1024/1024/1024),5) GB
 from dba_segments
group by owner,segment_name,segment_type
order by 3 desc;
user_77528540
Related