You can use Oracle Enterprise Manager to enable parallel execution servers in a single parallel operation to use multiple temporary tablespaces. A tablespace group name can appear where a tablespace name would appear when assigning a default temporary tablespace for the database or assigning a temporary tablespace for a user.
To manage temporary tablespace groups, follow these steps:
Navigate to the Database Home page.
On the Server tab under Storage, click Temporary Tablespace Groups.
The Temporary Tablespace Group page appears and displays the temporary tablespace groups that are defined for your database.
You can edit, create or delete temporary tablespace groups from this page.
Move to the Edit or Create Temporary Tablespace Group page and click Help for more information about temporary tablespace groups.
About Temporary Tablespace Groups
Enterprise Manager Information Roadmap
Copyright © 1996, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.