In Oracle Database we can add multiple temporary tablespace using tablespace groups, tablespace groups allowed to use multiple temporary tablespace to store temporary segments. The temporary tablespace group is created automatically when you add first tablespace is assigned a group.

How to add Multiple Temporary Tablespace

In Oracle Database we can add multiple temporary tablespaces using tablespace groups, tablespace groups allowed to use multiple temporary tablespaces to store temp segments. The temp tablespace group is created automatically when you add the first tablespace is assigned a group. Tablespace¬†and Group Name A tablespace group name and tablespace …

Read moreHow to add Multiple Temporary Tablespace