ORA-27040 Archives - Ed Chen Logic

How to Resolve ORA-27040: file create error, unable to create file

by Ed Chen
May 18, 2022December 17, 2022

ORA-27040 Tried to add a data file to a tablespace, but it failed with ORA-01119 and ORA-27040. SQL> ALTER TABLESPACE EXAMPLE ADD DATAFILE '/u01/app/oracle/oradata/ORCLCDB/ORCLPDBX/example02.dbf' SIZE… Read More »