create tablespace fails with ORA:02236
572227Apr 12 2007 — edited Apr 12 2007Hi,
Im getting this ORA-02236: Invalid file name while creating a tablespace. Below is the query i gave
SQL> create tablespace index1 datafile '/u01/oradata/testdb/index1_00.dbf' size 50M autoextend on;
Error at line 1:
ORA-02236: Invalid file name
Everything is perfect with this statement, like the directory exists, owned by oracle user, there is enough space on the disk, etc.
I was working with INITTESTDB.ORA before and there was no problem creating new tablespaces then. Recently i created SPFILE and the database is now working on SPFILE. I tried to add new tablespace that is where im getting this error. Is this anything related to these parameter files or is there any other problem?
Im working with 10gR2 on solaris 10
Any information will be of a great help
THanks,
Godwin.