Creating new tablespaces in 10gR2 [message #603118] |
Wed, 11 December 2013 08:55 |
|
joebegenwald@gmail.com
Messages: 7 Registered: October 2013
|
Junior Member |
|
|
I am manually creating a 10.2.0 db. I have gotten the database created and open. Now I am adding additional tablespaces. I have 5 similar CREATE TABLESPACE, all of which give me the same results as follows:
SQL> create tablespace users logging
2 datafile 'u01/oracle/oradata/butest1/users01.dbf'
3 size 25m autoextend on next 5m maxsize unlimited
4 extent management local;
create tablespace users logging
*
ERROR at line 1:
ORA-01119: error in creating database file
'u01/oracle/oradata/butest1/users01.dbf'
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
The directory positively exists (that is where the control, log, and dbf files were created by CREATE DATABASE. The actual files do not exist, but that is what I am trying to create.
Anyone see anything wrong with this statement? I spent three hours yesterday debugging my CREATE DATABASE statement before I found the extra comma, but I don't see anything wrong with this one.
I have tried this with and without the logging and reuse keywords.
|
|
|