Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error message on creating Table Space

939401May 24 2012 — edited May 24 2012

Hello All,

I am new to Oracle and trying to create a database after Oracle 10g installation. These are the steps followed. This looks to be something wrong I am doing, can someone please help?

SQL> Create Tablespace CLOUD_DATA datafile '$ORACLE_HOME/oradata/cloud_data01.dbf' size 1000M
autoextend on;
Create Tablespace CLOUD_DATA datafile '$ORACLE_HOME/oradata/cloud_data01.dbf' size 1000M
autoextend on
*
ERROR at line 1:
ORA-01119: error in creating database file
'$ORACLE_HOME/oradata/cloud_data01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the patch specified

Regs, /TT

This post has been answered by kuljeet singh - on May 24 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2012

Added on May 24 2012

#general-database-discussions

2 comments

743 views