Oracle Create tablespace error, ORA-01119: Create database file; ORA-27040: File creation error, unable to create file; O/s-error: (OS 3) The system could not find the specified path.

Scenario: Create a table space in Oracle, assuming the space name is tbsp_1, the file location is d:\app\administrator\oradata\orcl/, and the space size is 10M.

Steps:

To create SQL:
CREATE tablespace tbsp_1 datafile ' e:/oracle/product/10.2.0/tablespaces/weblogic.dbf ' SIZE 10M;

However, the following error message appears:
Error message:
ORA-01119: Error creating database file ' e:/oracle/product/10.2.0/tablespaces/weblogic.dbf '
ORA-27040: File creation error, unable to create file
OSD-04002: Unable to open file
O/s-error: (OS 3) The system could not find the specified path.

The solution is as follows:

Error Analysis:--------------------------The main problem with this error is that the file directory address that created the tablespace did not specify the correct

First, locate the Oracle installation directory file on my computer, as shown in the following figure:

Then modify the SQL statement "CREATE tablespace tbsp_1 datafile ' e:/oracle/product/10.2.0/tablespaces/weblogic.dbf ' SIZE 10M;" The file location in, and the modified statement is as follows:

CREATE tablespace tbsp_1 datafile ' d:\app\administrator\oradata\orcl/jcs_1_0_data.dbf ' SIZE 10M;

Executes the statement.

Finally, we see the table space Tbsp_1 created successfully in the following figure.