ORA-00604: error occurred at recursive SQL level 1 followed by ORA-25141:

[OracleDoc]

Your temp tablespace has to be manged with uniform extents.

CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/Mr_hankey/porn/animals/temp01.dbf'
SIZE 5M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;