ORA-01119

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 »

How to Resolve ORA-15005: name is already used by an existing alias

by Ed Chen
February 9, 2022February 11, 2022

ORA-15005 ORA-15005 means that there's already a file with the same name existing in the same path. Therefore, Oracle cannot create the file for you.… Read More »

How to Resolve ORA-27038: created file already exists

by Ed Chen
December 29, 2021May 18, 2022

ORA-27038 Tried to add a data file to a tablespace, but it failed with ORA-27038. SQL> alter tablespace example add datafile '/u01/app/oracle/oradata/ORCLCDB/ORCLPDB/example03.dbf' size 10m autoextend… Read More »