Temporary space....
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 26 Apr 2005 10:35:36 +0530
I have few confusions:
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?
2) whats the diff between the two commands:
create tablespace temp datafile .......... temporary;
create tablespace temp tempfile .......... temporary.
Thanx in advance
--=20
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
