建表空间时的路径名问题导致的ora—…

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




solution:give exact path of datafile inplace of $ORACLE_HOME.

like
Create Tablespace CLOUD_DATA datafile'/u01/app/oradata/cloud_data01.dbf' size 1000M