I found from Internet, that database software "Oracle 10g XE" should allow maximally 4GB of data:
>
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.
>
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
But i managed to create tablespaces that files exceed 4Gb if i look into my tablespaces folder in OS, also i see that oracle metadata tables show that 4Gb is exceeded:
select * from v$version;
/*
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
*/
SELECT Tablespace_Name,
Bytes / (1024 * 1024) Megs,
SUM(Bytes / (1024 * 1024)) Over() Megssum
FROM Dba_Data_Files;
/*
USERS 100 4760
SYSAUX 430 4760
UNDO 90 4760
SYSTEM 340 4760
UNDOTBS2 200 4760
DATA 2600 4760
INDX 1000 4760
*/
Why it allows to have tablespaces over 4Gb? How could i produce error message that would say that 4 Gigas are exceeded already? Can you explain me how i could see that really only 4 gigas of data is allowed for such Software?