Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Dropped a lot of tables but still getting ORA-12954: "The request exceeds the maximum allowed database size of 12 GB."

Jose ArósteguiMay 29 2025

Hi experts,

We're using 21XE and we've dropped several old backup tables with blob columns, but still get the max 12 GB error.

Using this SQL, it seems to be a lot of free space:

SELECT round(SUM(used.bytes) / 1024 / 1024 ) || ' MB' "Database Size"
     ,round(SUM(used.bytes) / 1024 / 1024 ) - round(free.p / 1024 / 1024 ) || ' MB' "Used space"
     ,round(free.p / 1024 / 1024 ) || ' MB' "Free space"
 FROM (SELECT bytes
         FROM v$datafile
       UNION ALL
       SELECT bytes
         FROM v$tempfile
       UNION ALL
       SELECT bytes
         FROM v$log) used
     ,(SELECT SUM(bytes) AS p
         FROM dba_free_space) free
GROUP BY free.p;

What can we do?
Thanks,
Jose

Comments
Post Details
Added on May 29 2025
5 comments
92 views