6,565 pts.
 Size of temp tablespace in Oracle 9i
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

Software/Hardware used:
ASKED: May 15, 2009  8:27 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _