[root@localhost ~]# su - oracle
[oracle@localhost ~]$ sqlplus /nolog
SQL> conn /as sysdba;
SQL> show user;
USER is "SYS"
SQL> select name from v$datafile;
//創建臨時表空間
create temporary tablespace xsgj_temp
tempfile '/opt/oradata/WULIU/xsgj_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//創建數據表空間
create tablespace xsgj_data
logging
datafile '/opt/oradata/WULIU/xsgj_data.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//創建用戶並指定表空間 http://hovertree.com/menu/oracle/
create user xsgj identified by xsgjmm
default tablespace xsgj_data
temporary tablespace xsgj_temp;
//給用戶授予權限
grant connect,resource to xsgj;
//授dba權限
grant dba to xsgj;
//授dblink權限
grant create public database link to xsgj;
//以後以該用戶登錄,創建的任何數據庫對象都屬於test_temp 和test_data表空間,這就不用在每創建一個對象給其指定表空間了。
附加:
表空間的位置可以用一下的查詢語句來查詢
select name from v$datafile;
推薦:http://www.cnblogs.com/roucheng/p/3504463.html