Originally posted by pando
it simply adds a tempfile so no matter what you do, rename it or delete it, it will still able to get a new tempfile
Originally posted by nagarjuna
Oracle does not add any tempfile physically, it just adds pointer to controlfile.. If you notice the controlfile trace, you can see that tempfile is being added using REUSE clause... It means, the file should be there allready..
But my controlfile dumped at trace says

Code:
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
# Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
# No tempfile entries found to add.
#
So where is my tempfile.. FILE IS NOT PHISICALLY PRESENT ON THE DISK.... I have renamed it.... as I have said it before.. so logically tempfile displayed by v$tempfile view doesn't PHYSICAL EXIST ON DISK AND ALSO NEW FILE IS NOT PHYSICALLY CREATED


Sameer