分类: Oracle
2015-05-25 15:06:32
#mklv -y lvname -T O -w n -s n -r n datavg 500 (500pps)
在两个节点分别修改如下权限:
#chown -R oracle:oinstall /dev/rlvname
#chmod -R 660 /dev/rlvname
sqlplus / as sysdba
SQL>create tablespace TBS_NAME datafile '/dev/rlvname' size 3000m;
SQL>create user USERNAME identified by XXXX default tablespace TBS_NAME;