oracle创建表空间和用户

–表空间
CREATE TABLESPACE drq1
DATAFILE ‘D:\tablespace\drq1.dmf’ size 800M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
–索引表空间
CREATE TABLESPACE drq_Index
DATAFILE ‘D:\tablespace\xx.dmf’ size 512M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

–2.建用户
create user drq identified by drq
default tablespace std;

–3.赋权
grant connect,resource to drq;
grant create any sequence to drq;
grant create any table to drq;
grant delete any table to drq;
grant insert any table to drq;
grant select any table to drq;
grant unlimited tablespace to drq;
grant execute any procedure to drq;
grant update any table to drq;
grant create any view to drq;