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.
精彩评论