We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this?
Moderator Note: This is a submitted question
May 15, 2009 8:27 PM