Temporary Tablespace Group

A temporary tablespace group can be thought of as a shortcut for a list of temporary tablespaces.
A temporary tablespace group consists of only temporary tablespaces.
A temporary tablespace group has the following properties:

[@more@]

?It contains at least one temporary tablespace. There is no explicit limit on how many tablespaces are contained in a group.
?It has the same namespace as tablespaces. It is not possible for a tablespace and a temporary tablespace group to have the same name.
?A temporary tablespace group name can appear wherever a temporary tablespace name appears (for example, while assigning a default temporary tablespace for the database, or assigning a temporary tablespace for a user).
?It is not explicitly created. It is created implicitly when the first temporary tablespace is assigned to it, and it is deleted when the last temporary tablespace is removed from the group.

Benefits
This feature has the following benefits:
?Enables one particular user to use multiple temporary tablespaces in different sessions at the same time
?Enables the slave processes in a single parallel operation to use multiple temporary tablespaces
?Enables multiple default temporary tablespaces to be specified at the database level

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/38542/viewspace-934762/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/38542/viewspace-934762/