--# 1.创建临时表空间
create temporary tablespace finance_temp tempfile 'D:\Oracle\finance_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
--# 2.创建表空间
create tablespace finance logging datafile 'D:\Oracle\finance.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
--# 3.创建用户
create user finance identified by finance default tablespace finance temporary tablespace finance_temp;
--# 4.用户授权
grant connect,resource,dba to finance;
--#更改用户密码 sys/orcl登录,执行下面语句
alter user finance identified by newpassword;
下面语句稍微改下就可以直接复制到sqlplus里直接运行:
create temporary tablespace finance_temp tempfile 'D:\Oracle\finance_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
create tablespace finance logging datafile 'D:\Oracle\finance.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
create user finance identified by finance default tablespace finance temporary tablespace finance_temp;
grant connect,resource,dba to finance;
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。