Oracle DBA, How To, Error, Cause and Action

ORA-01662: tablespace 'string' is non-empty and cannot be made temporary

ORA-01662: tablespace 'string' is non-empty and cannot be made temporary




Cause: Tried to convert a non-empty tablespace to a temporary tablespace




Action: To drop all the objects in the tablespace.