Hi guys In control file trace I could not see DEFAULT tempfile and dba_temp_files also does not have any record. But if I added any new temp tablespace I could see this in both? Could someone put a point on this please Thanks Syed -- //www.freelists.org/webpage/oracle-l