And select the temporary tablespaces that belong the group
Temporary Tablespace Group: Benefits
|
---|
|
---|
Therefore, you can now define more than one default temporary tablespace, and a single SQL operation can use more than one temporary tablespace for sorting. This prevents large tablespace operations from running out of temporary space. This is especially relevant with the introduction of bigfile tablespaces.
|
---|
Creating and Maintaining Temporary Tablespace Groups
Oracle Database 10g: Administration Workshop II G-16