From: Norris, Daniel (Daniel.Norris@gentiva.com)
Date: Mon Nov 04 2002 - 14:36:21 EST
I feel pretty silly-the answer was that Oracle creates temp tablespace
files as sparse files. Using "ls -ls" showed the clearer picture.
Thanks for all the quick replies.
========================================================================
===========
Original message:
Can anyone explain this:
# du -sk temp*
176 temp01.dbf
# ls -l temp*
-rw-r----- 1 oracle dba 2097160192 Nov 1 10:16 temp01.dbf
# cp temp01.dbf temptest.dbf
# du -sk temp*
176 temp01.dbf
2048008 temptest.dbf
# ls -l temp*
-rw-r----- 1 oracle dba 2097160192 Nov 1 10:16 temp01.dbf
-rw-r----- 1 root dba 2097160192 Nov 4 13:21 temptest.dbf
This has to be one of the weirdest things I've ever seen. Please help
me believe that I'm not going crazy.
Dan Norris
Unix Engineering, Gentiva
Celeritas Technologies, LLC
913-814-2675
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:48:58 EDT