I'm definitely sure you're putting the path wrong.
Please check that your mentioned path exists.
Just to be clear, SQL commands you enter from any client application, whether it is SQL*Plus, OEM, TOAD or anything else, are executed on your behalf by the database server. When you enter a CREATE TABLESPACE command and specify a path, a process owned by oracle (not you) will look on the server and attempt to create the file.
Originally Posted by dre1988
run a query on sql as
SQL > select FILE_NAME, TABLESPACE_NAME from dba_data_files;
you will get the location where current data files are use the same path to create ur tablespace , job done .
Click Here to Expand Forum to Full Width