在dos下连接到数据库
sqlplus / as sysdba
创建临时表空间
create temporary tablespace bi_temp tempfile 'D:\java\Oracle\data\bi_temp.dbf' size 64m autoextend on next 64m maxsize 2048m extent management local;
创建表空间
create tablespace bi_blog logging datafile 'D:\java\Oracle\data\bi_blog.dbf' size 64m autoextend on next 64m maxsize 2048m extent management local;
创建用户
create user bi_new identified by bi_new default tablespace bi_blog temporary tablespace bi_temp;
授权
grant connect, resource, unlimited tablespace to bi_new;
修改用户名密码
alter user bi_new identified by bsoft;
有兴趣的朋友可以关注下本人的微信公众号:“JAVA菜鸟程序猿”