ORA-01652 unable to extend temp segment by 64 in tablespace USR

select

srt.tablespace,

srt.segfile#,

srt.segblk#,

srt.blocks,

a.sid,

a.serial#,

a.username,

a.osuser,

a.status

from

v$session a,

v$sort_usage srt

where

a.saddr = srt.session_addr

order by

srt.tablespace, srt.segfile#, srt.segblk#,

srt.blocks;

select inst_id, tablespace_name, total_blocks, used_blocks, free_blocks from gv$sort_segment;

Cause: Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

ALTER TABLESPACE usr

ADD DATAFILE 'F:\CAPD1112\USERS02.ORA' SIZE 2048M

AUTOEXTEND ON

NEXT 1024M

MAXSIZE unlimited;