-
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?
example:
CREATE TABLESPACE ESB_GRANITE_CTS_DATA
DATAFILE
'/path_on_server' SIZE 200M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;
thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|