Restrictions on Oracle eXpress Edition data files

Restrictions on Oracle eXpress Edition data files
Restrictions on oracle XE are described as follows:
1. Express Edition is limited to a single instance on any server;
2. Express Edition may be installed on a multiple CPU server, but may only be executed on one processor in any server;
3. Express Edition may only be used to support up to 4 GB of user data (not including Express Edition system data );
4. Express Edition may use up to 1 gb ram of available memory.
The 3rd items indicate that the supported user data is 4 GB (excluding system data). The test is as follows:
C: \ Documents ents and Settings \ User> SQLPLUS "/as sysdba"
SQL * Plus: Release 9.2.0.1.0-Production on Sunday June 6 10:44:37 2010
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
Connect:
Oracle Database 10g Express Edition Release 10.2.0.1.0-Production
JCQ0> select * from v $ dbfile;
FILE #
----------
NAME
--------------------------------------------------------------------------------
4
E: \ ORACLEXE \ ORADATA \ XE \ USERS. DBF
3
E: \ ORACLEXE \ ORADATA \ XE \ SYSAUX. DBF
2
E: \ ORACLEXE \ ORADATA \ XE \ UNDO. DBF
1
E: \ ORACLEXE \ ORADATA \ XE \ SYSTEM. DBF
JCQ0> alter database datafile 4 resize 5G;
Alter database datafile 4 resize 5G
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> create tablespace test datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test01.dbf' size 4g;
The tablespace has been created.
JCQ0> alter database datafile 5 resize 5G;
Alter database datafile 5 resize 5G
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> alter tablespace add datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test02.dbf' size 5g;
Alter tablespace add datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test02.dbf' size 5g
*
ERROR is located in row 1st:
ORA-02140: Invalid tablespace name
JCQ0> alter tablespace test
2 add datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test02.dbf' size 5g;
Alter tablespace test
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> alter tablespace test
2 add datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test02.dbf' size 4g;
Alter tablespace test
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> alter tablespace test
2 add datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test02.dbf' size 1g;
Alter tablespace test
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> create tablespace test2 'e: \ ORACLEXE \ ORADATA \ XE \ test201.dbf' size 4g;
Create tablespace test2 'e: \ ORACLEXE \ ORADATA \ XE \ test201.dbf' size 4g
*
ERROR is located in row 1st:
ORA-02180: The create tablespace option is invalid.
JCQ0> create tablespace test2 datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test201.dbf' size
4g;
Create tablespace test2 datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test201.dbf' size 4g
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> create tablespace test2 datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test201.dbf' size
1g;
Create tablespace test2 datafile 'e: \ ORACLEXE \ ORADATA \ XE \ test201.dbf' size 1g
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> ----- database excluing system tablespace is 4 GB --------------
JCQ0 & gt; select sum (bytes)/1024/1024/1024 from dba_data_files;
SUM (BYTES)/1024/1024/1024
-------------------------
4.9375
JCQ0> alter database datafile 1 resize 4g;
Alter database datafile 1 resize 4g
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> alter database datafile 1 resize 2g;
Alter database datafile 1 resize 2g
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
JCQ0> alter database datafile 2 resize 2g;
The database has been changed.
JCQ0>
JCQ0> alter database datafile 3 resize 2g;
Alter database datafile 3 resize 2g
*
ERROR is located in row 1st:
ORA-12952: The request exceeds the maximum allowed database size 4 GB
After creating a 4 GB tablespace, you cannot add new data files to the tablespace. The system tablespace cannot be resize, but the undo tablespace can be resize.
It seems that the restrictions in this version are extremely strict.