例如:创建用户 cwbase1_9999 密码 gxtest 表空间 cwdata1
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 ;