Creating a Tablespace Remotely
version: Oracle 9.2
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;
Click Here to Expand Forum to Full Width