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