Re: ORACLE XE

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Sat, 15 Mar 2008 08:48:37 -0700 (PDT)
Message-ID: <546c4ed0-87d9-487f-bbb2-2b8b297124e1_at_i7g2000prf.googlegroups.com>

> 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 Received on Sat Mar 15 2008 - 16:48:37 CET