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.