0
According to official documentation from Oracle
available in https://www.oracle.com/br/database/technologies/appdev/xe/faq.html has the limitations:
What are the resource limits of Oracle Database 18c XE Oracle Database 18c XE supports:
3 Connected Databases 2 Cpus for Foreground Processes 2 GB RAM (combined SGA and PGA) 12 GB of user data on disk (irrespective of the compaction factor)
When running the SQL
select
TABLESPACE_NAME "Tablspace",
FILE_NAME "Filename",
BYTES/1024/1024 "Size MB"
from
SYS.DBA_DATA_FILES;
got the result:
Tablspace Filename Size MB
------------------------------ ------------------------------------------------------- ----------
USERS C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF 11,25
UNDOTBS1 C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF 4230
SYSTEM C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF 8630
SYSAUX C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF 900
Doubt
Which files the Oracle
consider to do the validation of 12GB of maximum size?
For if you do the sum of the four TableSpace
I’ve already passed 12 GB.