Bookshelf Home | Contents | Index | Search | PDF |
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
orTEMP_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 ofDBA_USERS
, and if any users are assigned to a tablespace other than the one allocated for temporary sort-type operations, correct the situation.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |