Home » Infrastructure » Windows » Clarification on the Oracle XE 4Gb limit (Oracle Express Edition)
Clarification on the Oracle XE 4Gb limit [message #468254] Thu, 29 July 2010 05:53 Go to next message
aidi-h
Messages: 45
Registered: November 2005
Member
In regard to the Oracle 4GB limit, what exactly is this limit?
Is this the total size of the datafiles of the user defined tablespaces (excluding SYSTEM and UNDO) so if, for example, we have a 2.8Gb datafile, can we only add another 1.2Gb datafile.

or is it the total size of extents/segments in the user defined tablespace i.e. if we have a 2.8Gb datafile but the database data comes to only 1.7Gb, can we add another tablespace with a new 2.8Gb datafile to allow for another 1.7Gb schema.

Any clarification would be appreciated.
Re: Clarification on the Oracle XE 4Gb limit [message #468257 is a reply to message #468254] Thu, 29 July 2010 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 67948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The limit is on RAM (SGA for Oracle) not on files.

Regards
Michel
Re: Clarification on the Oracle XE 4Gb limit [message #468329 is a reply to message #468257] Thu, 29 July 2010 13:14 Go to previous messageGo to next message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
Um - noooooo - Oracle XE allows only a 1gb SGA and only up to 4gb of tablespace . . . . . . . . http://www.oracle.com/technetwork/database/express-edition/overview/index.html
Re: Clarification on the Oracle XE 4Gb limit [message #468330 is a reply to message #468329] Thu, 29 July 2010 13:17 Go to previous messageGo to next message
Michel Cadot
Messages: 67948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Doh! I didn't see "XE".

Regards
Michel
Re: Clarification on the Oracle XE 4Gb limit [message #468333 is a reply to message #468330] Thu, 29 July 2010 13:46 Go to previous messageGo to next message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
Michel - out of 34501 posts, how many do you think you got it wrong in? 5? 10? Probably not more than 15. I think you are allowed a 'doh' once in a while. I am on the other hand am PERFECT!!!!
Re: Clarification on the Oracle XE 4Gb limit [message #468334 is a reply to message #468333] Thu, 29 July 2010 13:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing

Re: Clarification on the Oracle XE 4Gb limit [message #468335 is a reply to message #468334] Thu, 29 July 2010 14:31 Go to previous messageGo to next message
aidi-h
Messages: 45
Registered: November 2005
Member
Many thanks for the replies guys!!! I presume that the limitation is on the data itself i.e. I could have, for example a datafile at 100Gb (using a daft example I know) but the total sum of the extents/segments on the datafile comes to only 1.7Gb so XE will still operate. I could then add another tablespace with another 100Gb datafile and import 1.7Gb of data there and XE will still operate fine as we still only have a total of 3.4Gb of data there.
Many thanks again
Re: Clarification on the Oracle XE 4Gb limit [message #468338 is a reply to message #468335] Thu, 29 July 2010 14:48 Go to previous messageGo to next message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
You REALLY need to read the fine documentation that you can get to from the link I posted above. You can NOT have a tablespace that is over 4gb is size, so that means you can NOT have a 100gb datafile in use. The GUI for OracleXE controls your world quite strictly in XE land. What is it that you are trying to do exactly?
Re: Clarification on the Oracle XE 4Gb limit [message #468340 is a reply to message #468338] Thu, 29 July 2010 14:51 Go to previous messageGo to next message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
And to be clear, it's not 4gb limit per tablespace - it's you can not have more than 4gb of datafiles for your Oracle XE database defined.
Re: Clarification on the Oracle XE 4Gb limit [message #468341 is a reply to message #468338] Thu, 29 July 2010 15:00 Go to previous messageGo to next message
aidi-h
Messages: 45
Registered: November 2005
Member
ok to summarise, I have a tablespace with a single 2.7Gb datafile. one schema owns the objects therein and the total size of the extents comes to 1.7Gb. We want to export these objects and import them back onto the database but under a new schema name (and probably a new, different tablespace). This means that over both old and new tablespaces, we will have a total of 5.4Gb (2*2.7Gb) in datafiles and a total of 3.4Gb (2*1.7Gb worth of extents) in actual data.
The question is, will the proposed increase to 5.4Gb for our datafiles be a problem or will the XE database only hit issues when the 3.4Gb in actual data exceeds 4Gb.
Re: Clarification on the Oracle XE 4Gb limit [message #468344 is a reply to message #468341] Thu, 29 July 2010 15:21 Go to previous message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
I am pretty sure it's by size of the datafile - not data used in the datafile. Again - you should probably read the docs - but it's a simple enough thing to download XE and try it Wink.
Previous Topic: Oracle 10g
Next Topic: Which Windows Server for Oracle 10g R2??
Goto Forum:
  


Current Time: Thu Sep 23 07:29:51 CDT 2021