ORA-25153:Temporary Tablespace is Empty

ORA-25153: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.
Solution:
alter tablespace temp add tempfile ‘/u02/oradata/test/temp01.dbf size 200m reuse;
You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply