When check a datafiles location tablespace in schema, you need to verify the existing tablespace availability. This query will show you what’s there and how much space are free to use :

Query Check

SELECT file_name, bytes/1024/1024/1024 from dba_data_files
 where tablespace_name=‘TABLESPACE_NAME’;

www.diarycoding.com