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.