Unable to extend temp segment by 1024 in tablespace abc?

Oracle tried to allocate some space in the mentioned tablespace but could not find space there.

Easiest way to solve the problem is to add another datafile.

ALTER TABLESPACE yourtablespace ADD DATAFILE ‘/data/file/path/file.dbf’ size 500M autoextend on;

Or you can resize an existing datafile if you have space.

For adding a new datafile in the ASM location:

ALTER TABLESPACE yourtablespace ADD DATAFILE ‘+DISK_GROUP_NAME’ size 500M autoextend on;

That solved my problem!