Error: "ORA-01119," "ORA-27040," or "OSD-04002" when adding a datafile to a tablespace

book

Article ID: 159670

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

When addiing a datafile to an existing tablespace, the following errors appear:

  • ORA-01119: error in creating database file
  • ORA-27040: file create error, unable to create file
  • OSD-04002: unable to open file

ERROR at line 1:
ORA-01119: error in creating database file
'D:\ORACLE\ORADATA\PROTECT\LOB2_8.DBF'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified

Resolution

  • Ensure that the directory path exists or that you have spelled it correctly.
  • Ensure that the Protect user in the Oracle database has full permissions to create, access, and modify in that tablespace.

See Verify that the Protect database user has the correct privileges.