Home » RDBMS Server » Server Administration » Creating new tablespaces in 10gR2 (Oracle 10.2.0 Solaris 10)
Creating new tablespaces in 10gR2 [message #603118] Wed, 11 December 2013 08:55 Go to next message
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 #603120 is a reply to message #603118] Wed, 11 December 2013 08:57 Go to previous messageGo to next message
BlackSwan
Messages: 25797
Registered: January 2009
Location: SoCal
Senior Member
>datafile 'u01/oracle/oradata/butest1/users01.dbf'
not as above but as below
datafile '/u01/oracle/oradata/butest1/users01.dbf'
Re: Creating new tablespaces in 10gR2 [message #603121 is a reply to message #603118] Wed, 11 December 2013 08:57 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
You need a leading '/'.

--
update: too slow!

[Updated on: Wed, 11 December 2013 08:58]

Report message to a moderator

Re: Creating new tablespaces in 10gR2 [message #603124 is a reply to message #603120] Wed, 11 December 2013 09:13 Go to previous messageGo to next message
joebegenwald@gmail.com
Messages: 7
Registered: October 2013
Junior Member
Geez. I could have looked at THAT all day as well.

Thanks.
Re: Creating new tablespaces in 10gR2 [message #603128 is a reply to message #603124] Wed, 11 December 2013 09:17 Go to previous messageGo to next message
BlackSwan
Messages: 25797
Registered: January 2009
Location: SoCal
Senior Member
You have to learn to believe what the error messages tell you.
Re: Creating new tablespaces in 10gR2 [message #603146 is a reply to message #603128] Wed, 11 December 2013 14:12 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
BlackSwan wrote on Wed, 11 December 2013 16:17
You 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.
Previous Topic: CPU_COUNT
Next Topic: Problems logging in as SYSDBA
Goto Forum:
  


Current Time: Sat Jan 20 04:29:06 CST 2018

Total time taken to generate the page: 0.02483 seconds