oracle新建表空间与用户

例如：创建用户 cwbase1_9999 密码 gxtest  表空间 cwdata1

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

sqlplus / as sysdba   运行sql create tablespace cwdata1 logging datafile '/opt/oracle/data/cwdata1/cwdata1.dbf' size 30000m autoextend on next 500m maxsize unlimited extent management local;   create temporary tablespace cwdata1_temp tempfile '/opt/oracle/data/cwdata1/cwdata1_temp.dbf' size 1000m autoextend on next 500m maxsize unlimited extent management local;   create user cwbase1_9999 identified by gxtest DEFAULT TABLESPACE cwdata1 temporary tablespace cwdata1_temp;   grant create session to cwbase1_9999 ; --创建表的权限 grant create table to cwbase1_9999 ;   grant dba to cwbase1_9999  ;