Temporary Segments on Default Tablespace

I have noticed several temporary segments appearing on a tablespace that is not defined as a user's temporary tablespace. The segments' appearances coincide with an Oracle job queue entry running that is refreshing snapshots, then building indexes and executing "analyze table compute" on the snap shot tables.

The temporary segments appear on the DAT1 tablespace. All users are defined with DAT1 as the default tablespace and TMP1 as the temporary tablespace. Does anyone know why these temporary segments are not getting created on the TMP1 tablespace? Is it driven by the tablespace where the object resides or the user's default tablepace? Is there a way to get Oracle to use TMP1 for these segments?

TIA Sincerely,
Paul Kaiser

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 03 1998 - 14:35:46 CDT