Query temp space limit in Oracle

I want to run a query which takes a lot of temp space. However, I don't want the query to exhaust开发者_如何学C all the available temp space. How can this be achieved?

You can add a resource plan that limits it.

You can also create another temporary tablespace with a fixed size and assign the user running the query to that one.