I'm definitely sure you're putting the path wrong.
Please check that your mentioned path exists.
Printable View
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.Quote:
Originally Posted by dre1988
hi 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 .
HTH
MAX