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!

Fresh XE 11 db, 11 GB storage limitation hit on executing DDL with create statements only

pineSep 5 2019 — edited Sep 9 2019

Hi,

A fresh install of XE 11 on Windows 10 Enterprise. Created a user and then executed a DDL sql (generated from Data Modeler) with around 1k tables. On about 10k+ lines the following error is thrown:

Error report -

ORA-00604: error occurred at recursive SQL level 1

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

00604. 00000 -  "error occurred at recursive SQL level %s"

*Cause:    An error occurred while processing a recursive SQL statement

           (a statement applying to internal dictionary tables).

*Action:   If the situation described in the next error on the stack

           can be corrected, do so; otherwise contact Oracle Support.

The space used is:

TABLESPACE_NAME                    SIZEMB     FREEMB

------------------------------ ---------- ----------

SYSAUX                                660      23.94

UNDOTBS1                              380     211.75

USERS                               10690   10684.88

SYSTEM                                410          

The database is a clean install. The SQL file is quite clean without storage clauses. Why is XE reporting this error?

I have also tried to use exp/imp with rows=n, and the result is the same. At some point that error message is preventing further table creation.

Thanks in advance.

Comments
Post Details
Added on Sep 5 2019
10 comments
1,347 views