Originally posted by Sameer
Originally posted by pando
Code:
ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle_2/oradata/dev920/temp01.dbf' REUSE;
# End of tempfile additions.
#
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
Oh.. I wasn't aware of this... Thanks for the reply...

But then why can't I see this newly added tempfile on file system? (I mean physical file). My database starts and works perfectly....

Sameer
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..