Guidelines for Creating Temporary Oracle Database Tablespaces

Modify all of the user temporary tablespace definitions from the default of SYSTEM to the name of the temporary tablespace; for example, TEMP.

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 CRM.