2

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?

Nicolas Raoul
  • 1,334
  • 7
  • 22
  • 43

1 Answers1

1

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.

Gary
  • 1,839
  • 10
  • 14
  • Using Oracle XE I can't seem to be able to create a new APEX workspace. There is nothing like this: http://www.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 07:06