On Mon, 17 Jan 2005 10:07:35 -0700, Bryan Wells <bunjibry@xxxxxxxxx> wrote: > okay... another Newbie (dumb) question: > > how do I clear out temporary table space? You don't. Oracle handles it. The only time you might have to do anything is if you have users creating non-temporary segments in there (can happen if it wasn't created correctly and your users are particularly dangerous, i.e. developers). In that case you'll have to drop or move the objects to a different tablespace, change your dba passwords and then find something heavy to chastise the users with. :-) > Whats the difference beteween temp space and temporary tablespace? Depends what you mean by temp space (and your OS). The temporary tablespace is a tablepace where Oracle creates temporary segments. Everything is handled 'under the hood', you might need to think about it for tuning purposes but other than that, barring bugs and the amove mentioned users, probably not. If by tempspace you mean operating system temp it depends somewhat on your operating system. In general it's a dumping ground for any temporary files tha the OS uses or needs for the duration of a process. For example under most versions of UNIX the vi text editor will keep undo and recovery information (not to be confused with Oracle UNDO (i.e. rollback) and recovery (i.e. redo) infomation) about the file that you're working on in the /tmp filesystem, under Windows most verson of MSIE will download a file to c:\temp or c:\windows\temp and then copy it to the location you designate (which is why you often get a disk space error when downloading large files even if the drive you're downloading to has more than enough space, there's not enough space on the drive your temp directory is on). Under some OSes (Solaris being an example) the tempspace is also used for swapping and paging when memory gets full. Stephen -- It's better to ask a silly question than to make a silly assumption. -- //www.freelists.org/webpage/oracle-l