Forum Stats

  • 3,876,077 Users
  • 2,267,057 Discussions
  • 7,912,420 Comments

Discussions

tablespace creation error

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..

Tagged:

Answers