How to fix ORA-01110

This problem happens when you delete a tablespace on the file system

Then when Oracle DB is not able to find it and return an exception as follows:

ORA-01110: data file 5: '/u01/app/oracle/oradata/XE/data'

This can be fixed by letting the oracle DB know that the file is deleted as follows:


Comments