Cause: An attempt to alter the specified tablespace temporary failed because the tablespace is in force logging mode. See the solution below.
Error solution: Put the tablespace out of force logging mode by ALTER TABLESPACE NO FORCE LOGGING command.
Database version: Oracle 11g Release 2 (11.2)