Temporary Tablespace is Empty
Posted on 2013-06-21
I'm getting an error. I've researched it but still not sure what to do.
select dbms_metadata.get_ddl ('PACKAGE_BODY','<<package name>>') from dual
And I get...
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_METADATA", line 5088
ORA-06512: at "SYS.DBMS_METADATA", line 7589
ORA-06512: at line 1
25153. 00000 - "Temporary Tablespace is Empty"
*Cause: An attempt was made to use space in a temporary tablespace with
*Action: Add files to the tablespace using ADD TEMPFILE command.