|
|
|
Re: error ORA-25153: Temporary Tablespace is Empty [message #404516 is a reply to message #404504] |
Fri, 22 May 2009 01:22 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
ORA-01516: nonexistent log file, datafile, or tempfile \"%s\"
*Cause: An attempt was made to use ALTER DATABASE to rename
a log file, datafile, or tempfile; or to change attributes
of a datafile or tempfile (e.g., resize, autoextend,
online/offline, etc.); or to re-create a datafile.
The attempt failed because the specified file
is not known to the database's control file
or is not of a type supported by the request.
*Action: Specify the name or number of an existing file
of the correct type, as appropriate.
Check the relevant V$ table for a list of possible files.
If you do not post the statement you try to execute the only thing we can answer is a copy of the error message from the documentation.
Be sure you add a temp file and not a data file.
Regards
Michel
|
|
|