Hi,
I have a tablespace called DDATA that has 2 datafiles.

The datafiles are:
/u02/or0/devdata_data01.dbf
/u02/or0/devdata_data02.dbf

I checked OEM schema manager and the datafiles
/u02/or0/devdata_data01.dbf has
SIZE USE
1000 998

/u02/or0/devdata_data02.dbf has
SIZE USE
500 200

and all of these files point to the same tablespace.

I am thinking about adding another datafile since the first datafile(/u02/or0/devdata_data01.dbf) is running out of space, but I don't know if it's neccessary or not, because the second datafile has quite some space. I quite confused if to add another datafile or not because one datafile is running out of space and the other datafile seems to be fine.
These datafiles point to the same tablespcae, so I dont know if I have to add another datafile for that same tablespace.
Can some one please give me some advice about what is going on?