Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

tablespace creation error

User_6ODMVSep 28 2022

This worked

CREATE TABLESPACE test1
DATAFILE 'G:\app\oraclehome12c\oradata\orcl\test1.dbf'
SIZE 800M;

This failed

CREATE TABLESPACE test2
DATAFILE 'G:\app\oraclehome12c\oradata\orcl\test2.dbf'
EXTENT MANAGEMENT local
AUTOALLOCATE
SEGMENT SPACE MANAGEMENT auto;

error received

CREATE TABLESPACE test2
*
ERROR at line 1:
ORA-01119: error in creating database file
'G:\app\oraclehome12c\oradata\orcl\test2.dbf'
ORA-17610: file 'G:\app\oraclehome12c\oradata\orcl\test2.dbf' does not exist
and no size specified
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

I fairly new to oracle..

Comments

Post Details

Added on Sep 28 2022
#12c, #general-database-discussions, #oracle, #sqlplus
2 comments
720 views