File_System_Full Error

Hi Friends,

In my production system of ECC 6.0, AIX, Oracle 10g, while doing the DB check, I've encountered the following error messages

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/RP1/sapdata1, value: 99.74% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/RP1/sapdata4, value: 99.75% (> 99%)

The datafiles that are currently being accessed are in the sapdata6 directory where there is ample space.

When I access any table which is in the datafile on the sapdata1, then in that condition will not create a problem. Can I identify what tables are store in which of the datafiles in sapdata1 for eg.

Will the above situation cause a problem on the performance of the DB....

Request you to kindly guide

Thanks....

Aliila