pl/SQL登陆选择数据库sysdba
执行以下操作,a2dw为数据库名字
// 创建表空间
create tablespace a2dw
datafile 'F:/oradata/a2dw.dbf' size 8M
autoextend on
next 5M
maxsize unlimited;
// 创建临时表空间
create temporary tablespace a2dw_temp
tempfile'F:/oradata/a2dw_temp.dbf' size 8M
autoextend on
next 5M
maxsize unlimited;
/ 创建用户并指定表空间
create user a2dw identified by a2dw
default tablespace a2dw
temporary tablespace a2dw_temp;
// 给用户授予权限
grant connect, resource to a2dw;
// 给用户授予dba权限
grant dba to a2dw;
create tablespace a2dw
datafile 'F:/oradata/a2dw.dbf' size 8M
autoextend on
next 5M
maxsize unlimited;
// 创建临时表空间
create temporary tablespace a2dw_temp
tempfile'F:/oradata/a2dw_temp.dbf' size 8M
autoextend on
next 5M
maxsize unlimited;
/ 创建用户并指定表空间
create user a2dw identified by a2dw
default tablespace a2dw
temporary tablespace a2dw_temp;
// 给用户授予权限
grant connect, resource to a2dw;
// 给用户授予dba权限
grant dba to a2dw;