aix下oracle数据库创建表空间和用户

#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;