I know that there are other questions about this topic but reading and trying them they cannot solve my problem. Mainly because
select * from DBA_DATA_FILES; shows me an error when executing, because the table doesn't exist in the database.
I know the different tablespaces using the following query, also looking not standard :
SELECT * FROM USER_TABLESPACES;
The ORA error ORA-01652 was thrown when executing a request which should use many temporary space.
The problem is that i don't know the datafiles location for this tablespace to execute the solution request
ALTER TABLESPACE ADD DATAFILE