First, check in DBA_USERS view what tablespace (for temporary purpose) is defined for a user.

select username, TEMPORARY_TABLESPACE from dba_users;

Then you can test with "create index script" or "select c1, sum(c2) from 10M_rows_big_table group by c1 "

Tamil