Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring an Oracle Database for Siebel Applications >

Guidelines for Creating Temporary Oracle Table Spaces

This topic is part of Configuring an Oracle Database for Siebel Applications.

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

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