RE: Temporary space....

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