On 07/01/2005 06:15:19 AM, Sinardy wrote: > Why Oracle allow to have temporary tablespace without the temp file? Because tablespace is a logical and not a physical structure. > > What should I do? Add one. -- Mladen Gogala Oracle DBA -- //www.freelists.org/webpage/oracle-l