Creating a Tablespace Remotely

[thomasp]

I'm definitely sure you're putting the path wrong.
Please check that your mentioned path exists.

[WilliamR]

slimD,

i'm connected to the DB server via SQLPlus from my desktop. i've got a tnsnames entry for the DB and the system login to it. that's it. i have no operating system account for the server at this point or an OEM login to its management server instance. this is the error:

ERROR at line 1:
ORA-01119: error in creating database file '/path_on _server/file.dbf'
ORA-27040: skgfrcre: create error, unable to create file
SVR4 Error: 2: No such file or directory

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.

[maxdbo]

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