ORA-25153: Temporary Tablespace is Empty & ORA-06512: at "SYS.NAME_SECURITY", line 166

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/uo1/database/myprod/ myprod _temp_01.dbf' Size 2G;

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-25153: Temporary Tablespace is Empty

ORA-06512: at "SYS.NAME_SECURITY", line 166

ORA-06512: at line 2

SQL> Alter trigger SYS.NAMECHECK_BEFORE_DDL_DB_TRG disable;

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/uo1/database/myprod/ myprod _temp_01.dbf' Size 2G;

Tablespace altered.

SQL> Alter trigger SYS.NAMECHECK_BEFORE_DDL_DB_TRG enable;