Home » RDBMS Server » Server Administration » error ORA-25153: Temporary Tablespace is Empty (merged)
error ORA-25153: Temporary Tablespace is Empty (merged) [message #404495] Fri, 22 May 2009 00:27 Go to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
HI!
I am fire a command "Alter Index <Index Name> Rebuils;"
then it give error
ORA-25153: Temporary Tablespace is Empty
Please help me to resolve this error.
Re: error ORA-25153: Temporary Tablespace is Empty [message #404496 is a reply to message #404495] Fri, 22 May 2009 00:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
25153, 00000, "Temporary Tablespace is Empty"
// *Cause: An attempt was made to use space in a temporary tablespace with
// no files.
// *Action: Add files to the tablespace using ADD TEMPFILE command.
Re: error ORA-25153: Temporary Tablespace is Empty [message #404504 is a reply to message #404496] Fri, 22 May 2009 00:49 Go to previous messageGo to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
when i fire Add Tempfile command it dispaly an error
"ORA-01516: nonexistent log file, datafile, or tempfile "/oracle/product/9.2.1.0/oradata/TCI9I/temp01.dbf""
Re: error ORA-25153: Temporary Tablespace is Empty [message #404516 is a reply to message #404504] Fri, 22 May 2009 01:22 Go to previous message
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
Previous Topic: What is the maximum number of role in the database
Next Topic: date oracle (merged 3)
Goto Forum:
  


Current Time: Fri Nov 29 13:51:50 CST 2024