Locally-managed temp tablespace question

[Guang Mei]

Oracle 8173 on Solaris 2.8:

bash-2.03$ pwd
/oracle/u02/oradata/YPD

bash-2.03$ df -k|grep /oracle/u02
/dev/dsk/c1t2d0s0 70592505 45549803 22924927 67% /oracle/u02

bash-2.03$ ls -l templmt*
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:40 templmt01.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt02.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt03.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt04.dbf
-rw-r----- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt05.dbf

bash-2.03$ rm templmt*

bash-2.03$ df -k|grep /oracle/u02
/dev/dsk/c1t2d0s0 70592505 44244651 24230079 65% /oracle/u02

I thought I should get 10GB (2097160192 x 5) back, but instead I got only 1.3MB ( 24230079 - 22924927) released. Could someone explain? BTW, when I created the temp files (templmt0[1-5]) for locally-managed temp tablespace, I found they were created extremely fast, so I suspected that not real disk space were allocated. But the "ls -l" command still showed 10GB were allocated.

TIA.

Guang Mei

[EMAIL PROTECTED]
http://www.geocities.com/guangmei/







_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 3 months FREE*. http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU= http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_stopmorespam_3mf

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).