ORA-25153: Temporary Tablespace is Empty

BR0301E SQL error -25153 at location stats_tab_collect-69, SQL statement:
'EXECUTE stmt_1d'
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"CCSELTAB"', ESTIMATE_PERCENT => 30, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => T
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1
BR0886E Collecting statistics failed for table SAPSR3.CCSELTAB
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0883I Table selected to collect statistics after check: SAPSR3.SDBAR (1/1:0:0)
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0881I Collecting statistics for table SAPSR3.SDBAR with method/sample C ...
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0884I Statistics collected for table: SAPSR3.SDBAR, rows old/new: 1/2
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0850I 1 of 5 objects processed - 0.001 of 0.004 units done
BR0204I Percentage done: 20.00%, estimated end time: 18:09
BR0001I **********________________________________________
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0883I Table selected to collect statistics after check: SAPSR3.TBTCS (37/463:920:462)
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0881I Collecting statistics for table SAPSR3.TBTCS with method/sample C ...
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0301E SQL error -25153 at location stats_tab_collect-66, SQL statement:
'EXECUTE stmt_1a'
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"TBTCS"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TR
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1
BR0886E Collecting statistics failed for table SAPSR3.TBTCS
BR0280I BRCONNECT time stamp: 2015-01-22 18.09.23
BR0879I Statistics checked for 34001 tables


Solution

SQL> alter tablespace PSAPTEMP add tempfile='H:\oracle\gwd\sapdata1\temp_1\temp.
data1' reuse;
alter tablespace PSAPTEMP add tempfile='H:\oracle\gwd\sapdata1\temp_1\temp.data1
' reuse
                                      *
ERROR at line 1:
ORA-02236: invalid file name

SQL> alter tablespace PSAPTEMP add tempfile 'H:\oracle\gwd\sapdata1\temp_1\temp.
data1' reuse;
Tablespace altered.
SQL> commit;
Commit complete.
SQL>