They are "sparse" ie the space is not allocated until required. On some OS's you can workaround it by copying the file elsewhere and then copying it back.
hth connor --- Guang Mei <[EMAIL PROTECTED]> wrote: > 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). > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
