I Installed Oracle Express Edition in my system..
In this am creating tablespace, while creating am getting error as below:
SQL> create tablespace eff datafile 'C:\oraclexe\oradata\XE\effpts.dbf' size 20m
create tablespace eff datafile 'C:\oraclexe\oradata\XE\effpts.dbf' size 20m
ERROR at line 1:
ORA-12952: The request exceeds the maximum allowed database size of 4 GB
Plz give solution...
Thanks in advance..
I assume you have installed XE 10G.
10G XE user data limit is 4GB.
11G XE user data limit is 11GB. Maybe you like upgrade
Documentation provide steps how you can upgrade.
BTW, This is Application Express forum (APEX) and your question do not relate this product.
Oracle Database Express Edition (XE) forum is here Oracle Database Express Edition (XE)
My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0