Re: disk space issue

It is difficult to decipher your problem from the information presented. If you are using a locally managed temporary tablespace for your temp table and having sort or index operations fill it up, you are just seeing the way it works. Look on metalink for a description of this ( like
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=177334.1 ) and the commands to make it clear if you really think you need to - if you do (as in some runaway job made it much larger than you want), it is usually easier to just drop it and create a new one.

As far as the log file, are you running in archivelog mode? Sounds like you have some serious misconfiguration or misapprehensions. See the concepts manual and faqs.

See http://members.cox.net/oracleunix/readme-cdos.htm

jg

--
@home.com is bogus.
Shrinkage:
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=275108.1