Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Creating separate tablespaces is possible in expensive versions of Oracle, but I can't seem to find a way to do so with the free version Oracle XE.

The administration interface just has a "View tablespaces" button, where I can see four tablespaces, SYSAUX, SYSTEM, UNDO, and USERS where all of my data seems to reside.

Is it a limitation of Oracle XE?
Or did I overlook something?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

If you create a new APEX workspace it should offer to create it in a new tablespace. Alternatively, fire up SQL*Plus (called the Command Line Interface in XE) and use the CREATE TABLESPACE command.

That said, given the 4GB limit, for a home install I resize the USERS tablespace to the maximum and just use that. Too annoying having reached the 4GB max and having space available in tablespace_a and not being able to expand tablespace_b when you want it there.

In theory you can shrink tablespace_a but that only works if the free space is at the end and not at the start or in the middle.

share|improve this answer
    
Using Oracle XE I can't seem to be able to create a new APEX workspace. There is nothing like this: dba-oracle.com/images/htmldb_manage_workspaces.jpg But the SQL command line allows the CREATE TABLESPACE command so I will give it a try, thanks :-) –  Nicolas Raoul Jan 22 '10 at 7:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.