i need to create a tablespace whose datafile resides on the database server. however, i can only access the database remotely via sql*plus (no OEM login). is there a way to create the tablespace like this even though the path to the datafile applies only to the server?
CREATE TABLESPACE ESB_GRANITE_CTS_DATA
'/path_on_server' SIZE 200M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
You've already logged into the database server to execute the command, right? Are you getting an error or something?
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