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