| 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.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Creating new tablespaces in 10gR2 [message #603146 is a reply to message #603128] |
Wed, 11 December 2013 14:12  |
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
|
Senior Member |
|
|
BlackSwan wrote on Wed, 11 December 2013 16:17You have to learn to believe what the error messages tell you.
That is very trough.
It have been infinite times that I just did not really understood/believed what the errors was telling me. I could have saved days if I started believing what the error-messages are telling me from day one.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
