命令创建表空间和用户

--创建临时表空间
create temporary tablespace test_temp
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 5m maxsize 1024m
extent management local;
--创建表空间
create tablespace test_gsww(表空间名称) logging
datafile 'C:\oracle\product\10.1.0\oradata\oa\gsww.dbf'
size 1024m
autoextend on
next 5m maxsize 1024m
extent management local;
--创建数据表空间
create tablespace test_gsww
logging
datafile 'C:\oracle\product\10.1.0\oradata\oa\gsww.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
--创建用户并指定表空间
create user test_gsww(用户名) identified by test_gsww(用户密码)
default tablespace test_gsww(表空间名)
temporary tablespace test_temp;
--给用户授予权限
grant connect,resource to test_gsww; (db2：指定所有权限)

--创建表空间
create tablespace docexchange logging
datafile '/oracle/oradata/orcl/docexchange.dbf'
size 1024m
autoextend on
next 10m maxsize unlimited
extent management local;
--创建用户并指定表空间
create user docexchange identified by doc
default tablespace docexchange;
--给用户授予权限
grant dba,connect,resource to docexchange;