ORA-01658 ORA-01119

[Thiko]

can someone please tell me whats wrong with this?

after getting an

ORA-01658: unable to create INITIAL extent for segment in tablespace <tablespace_name>

i decided to try to add another datafile to the tablespace to add additional space.

alter tablespace <tablespace_name>
add datafile '/data/oracle/<tablespace_name>.ORA'
autoextend on
next 1024 k
maxsize 2147483645;

ORA-01119: error in creating database file '/data/oracle/mount3/NOL_DEVELOPERS_TESTDB2.ORA'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: Many Thanks.

Thiko!

 

[Thiko]

syntax error..........:

alter tablespace <tablespace_name>
add datafile '/data/oracle/mount3/<tablespace_name>'
size 100M
autoextend on
next 10
maxsize 1500M ; Many Thanks.

Thiko!