Expand the temporary table space

1. Execute the following command to create a new temporary table space.

create bigfile temporary tablespace user_temp tempfile '+DATA/orcl/tmp1.dbf' size 300g autoextend on extent management local;

The parameters are as follows:

• DATA—Disk group name.

• orcl—Instance name.

2. Replace the old space with the new one.

alter database default temporary tablespace user_temp;

drop tablespace temp including contents and datafiles;// Make sure log groups are enough.

alter tablespace user_temp rename to temp

select name from v$tempfile  //View the temporary table space.