OraFAQ Forum: Server Administration » Creating new tablespaces in 10gR2

Home » RDBMS Server » Server Administration » Creating new tablespaces in 10gR2 (Oracle 10.2.0 Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Creating new tablespaces in 10gR2 [message #603120 is a reply to message #603118]

Wed, 11 December 2013 08:57

BlackSwan
Messages: 26766
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'

Report message to a moderator

Re: Creating new tablespaces in 10gR2 [message #603121 is a reply to message #603118]

Wed, 11 December 2013 08:57

John Watson
Messages: 8976
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

joebegenwald@gmail.com
Messages: 7
Registered: October 2013

Junior Member

Geez. I could have looked at THAT all day as well.

Thanks.

Report message to a moderator

Re: Creating new tablespaces in 10gR2 [message #603128 is a reply to message #603124]

Wed, 11 December 2013 09:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You have to learn to believe what the error messages tell you.

Report message to a moderator

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: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.

Report message to a moderator

Previous Topic:	CPU_COUNT
Next Topic:	Problems logging in as SYSDBA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 23:35:55 CDT 2025