SQLPLUS 以管理員(sys)登陸數(shù)據(jù)庫
#sqlplus '/as sysdba'
創(chuàng)建臨時表空間
create temporary tablespace mven_temp
tempfile '/opt/oracle/oradata/mven/mven_temp.dbf'
size 128m;
創(chuàng)建數(shù)據(jù)表空間
create tablespace mven
logging
datafile '/opt/oracle/oradata/mven/mven.dbf'
size 2048m;
創(chuàng)建用戶并指定表空間
create user mven identified by OracleUserMven
default tablespace mven
temporary tablespace mven_temp;
給用戶授予權(quán)限
grant connect,resource to mven;
新聞熱點
疑難解答
圖片精選