Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an Oracle Database for Siebel Business Applications >
Guidelines for Creating Temporary Oracle Tablespaces
Modify all of the user temporary tablespace definitions from the default of
SYSTEM to the name of the temporary tablespace; for example,
To find out which users are assigned to which temporary tablespaces, query the TEMPORARY_TABLESPACE column of DBA_USERS. If any users are assigned to a tablespace other than the one allocated for temporary sort-type operations, then correct the situation.
This topic is part of Configuring an Oracle Database for Siebel Business Applications.