Getting ORA-01652 error when Run oracle sql query join into approx 10 tables

I have three users on oracle and they have same tablespace, When I run following query I am getting following problem when executing query. And also while executing it takes a hell lot of time :(I have three users on oracle and they have same