Hi Below you find two links that should answer your questions. My general = advice is to read, at least twice, the whole book. It's name is: = Concepts. >1) In my temporary tablespace, space not getting released even if the >user has finished with the work. Ideally once the user using temporary >tablespace, finished the job, space in the temporary tablespace used >by the user should be released. But its not. Any idea why? http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c03bl= ock.htm#2930 >2) whats the diff between the two commands: > create tablespace temp datafile .......... temporary; > create tablespace temp tempfile .......... temporary. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c04sp= ace.htm#10561 HTH Chris -- http://www.freelists.org/webpage/oracle-l