//生成用户
cnernstr
1.登陆系统
sqlplus sys/change_on_install as sysdba;
drop user
cnernstr
cascade;
DROP TABLESPACE
db_cnernstr
INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE
db_cnernstr_temp INCLUDING CONTENTS AND DATAFILES;
create tablespace
db_cnernstr
logging
datafile 'D:\app\wangfengyang\oradata\
db_cnernstr.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create temporary tablespace
db_cnernstr_temp
tempfile 'D:\app\wangfengyang\oradata\
db_cnernstr_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
7.创建用户(用户cnernstr ,密码 carboncloud)
create user
cnernstr identified by carboncloud
default tablespace
db_cnernstr
temporary tablespace
db_cnernstr_temp;
8.用户授权(cnernstr )
grant connect,resource,dba to cnernstr ;
grant create view to
cnernstr ;