oracle创建表空间、用户
//创建临时表空间?
create temporary tablespace tpts_temp?
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\tpts_temp01.dbf'?
size 32m?
autoextend on?
next 32m maxsize 2048m?
extent management local;?
//创建数据表空间?
create tablespace ts_name?
logging?
datafile 'D:\oracle\product\10.2.0\oradata\orcl\ts_name01.dbf'?
size 32m?
autoextend on?
next 32m maxsize 2048m?
extent management local;?
//创建用户并指定表空间?
create user username identified by password?
default tablespace?ts_name??
temporary tablespace tpts_temp;?
//给用户授予权限?
grant connect,resource to username;?
