To see a list of tablespaces in Oracle, issue the following query:
SELECT tablespace_name FROM dba_tablespaces;
Once you know which tablespace you want to house your table, you can create your table similar to the following:
CREATE TABLE my_table ( id NUMBER, name VARCHAR2(30)) TABLESPACE user_tablespace;
The TABLESPACE clause in the CREATE TABLE command instructs Oracle to
place the table in the correct location.
This was first published in July 2004