Siebel Server Installation Guide for Microsoft Windows > Creating the Oracle Database > Creating the Database >

Creating Temporary Tablespaces

All user temporary tablespace definitions should be modified from the default of SYSTEM to the name of the temporary tablespace; for example, TEMP or TEMP_TS. Otherwise, SORT operations interfere with Oracle dictionary management.

To find out which users are assigned to which temporary tablespaces, query the TEMPORARY_TABLESPACE column of DBA_USERS, and if any users are assigned to a tablespace other than the one allocated for temporary sort-type operations, correct the situation.

 Siebel Server Installation Guide for Microsoft Windows 
 Published: 25 June 2003