Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to resize 11g express datafile.

947771Jan 17 2013 — edited Jan 18 2013

Hi,

i am using 11g express,windows 2008, (new bie)

i want to extend the size of userdata file. becasue while inserting record it is showing database has reached it's maximum size 11GB.

1) Please tel me solution, because i heard there is limitation in express edition.

2) why in document it is written "oracle Database XE storage is limited to 5 GB", but it is showing message that it has reached maxsize 11gb,
and when i calculated max space of table space it was 32767.984375+600+32767.984375+11264+32768 =110168
and when i caluclated max space of dataifle it was 32767.984375+600+32767.984375+11264=77400 ( temp was not showin in report of datadisctionary)

3) and from where i should run this command system or sys , ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf'
RESIZE 11000M; that is 11Gb of size.

yours sincerely

Edited by: 944768 on Jan 17, 2013 8:06 AM

Edited by: 944768 on Jan 17, 2013 10:32 PM

Edited by: 944768 on Jan 17, 2013 10:41 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2013

Added on Jan 17 2013

5 comments

6,214 views