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!

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

DesinxSep 28 2021 — edited Sep 28 2021

Hello,
I have an Oracle 11g XE installation that has started throwing "ORA-12953: The request exceeds the maximum allowed database size of 11 GB" when insert is attempted on some schema tables. I am sure I don't have data that is anywhere near 11G on all my schemas.
I was hoping someone can point me to what I should be cleaning to get rid of this error. Please see the results from dba_data_files query. I assume from what I have read that SYS, SYSAUX, UNDOTBS1 do not count towards the DB size limit.
Thank you.
schemas.PNG

Comments
Post Details
Added on Sep 28 2021
1 comment
1,574 views