一、创建表空间
create tablespace SBDSPACE
datafile 'D:/oracle_tablespaces/SBDSPACE_TBSPACE.dbf'
size 1500M
autoextend on next 5M maxsize 3000M;
二、创建用户
create user shen identified by "123";
grant create session to shen;
grant create table to shen;
grant create tablespace to shen;
grant create view to shen;
grant dba to shen;//赋DBA权限
grant connect,resource to shen;
grant create any sequence to shen;
grant create any table to shen;
grant delete any table to shen;
grant insert any table to shen;
grant select any table to shen;
--grant unlimited tablespace to shen;
grant execute any procedure to shen;
grant update any table to shen;
grant create any view to shen;
三、授予用户使用表空间的权限
alter user shen quota unlimited on SBDSPACE
四、Oracle执行Sql脚本
在命令窗口中输入:@E:\路径\**.sql;