When tablespace full in schema, you need to resize tablespace. This query will resize tablespace (resize to 20 Gb) :

Query Alter

alter database datafile ‘+DATA/DIARYCODING/DATAFILE
/diarycoding.305.978198771’ resize 20G ;

www.diarycoding.com