Sent: Friday, September 19, 2003 6:24
PM
Subject: Fwd: Re: Tempfile
weirdness
funny how my previous email seems to have been truncated
where I put three dots [ie , "."] tosignifiy 3 lines.Resend
:For a critical database where I want to be SURE that the file system
has en
funny how my previous email seems to have been truncated where I put
three dots [ie , "."] to
signifiy 3 lines.
Resend :
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
U
For a critical database where I want to be SURE that the file system has
enough space for the
TempFile, I run a large
SELECT * FROM DBA_SOURCE
UNION
SELECT * FROM DBA_SOURCE
UNION
It also can be caused by bad sectors or other hardware errors, but I'd bet
on sparse file problem as you described.
When I create temp tablespaces, I either copy the tempfile into another
filename and then rename to original using cp, that way the file isn't
sparse anymore, thus no problems using i
We also ran into the IO error situation on a few of our 9i R2 databases using
TEMPfiles.
DBAs forgot that the file system contained those tempfiles and created other datafiles
on those.
We are now considering using dedicated file system naming convention that will hold
TEMPfiles. We
already have