I have hours worth of unkind words for anyone who would do what you did in a production database without first validating their actions in an active test environment. As I do not like using such words in a public forum please stand in front of a mirror and repeat everything you think I would say. Then promise to never, ever, do it again. Thank you. I feel better.
select username, temporary_tablespace from dba_users;