Re: ORACLE XE

> I've always wondered if 4GB also includes indexes or is it just pure user
> data..
Sum of tablespaces simply cannot be bigger than that.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> create table q (a number)
  2  tablespace system storage (initial 5g);
create table q (a number)
*
ERROR at line 1:
ORA-12952: The request exceeds the maximum allowed database size of 4
GB
SQL> create table q (a number)
  2  tablespace users;

Table created.
SQL> create index qidx on q (a)
  2  tablespace users storage (initial 5g);
create index qidx on q (a)
                     *
ERROR at line 1:
ORA-12952: The request exceeds the maximum allowed database size of 4
GB

BTW actually it seems that the upper level is 5G including ~4G user
data and ~1G system data - system and sysaux tablespace, which
actually can include also some user tables.
  1  select TABLESPACE_NAMe,
  2         to_char(sum(bytes/1024/1024/1024), '9999999.99') "Size
GBytes"
  3  from dba_data_files
  4  where TABLESPACE_NAMe <> 'UNDO'
  5* group by rollup(TABLESPACE_NAMe)
SQL> /

TABLESPACE_NAME                Size GBytes
------------------------------ -----------
SYSAUX                                 .50
SYSTEM                                 .34
USERS                                 4.15
                                      4.99

Gints Plivna
http://www.gplivna.eu