Oracle创建表空间

1.创建临时表空间

create temporary tablespace user_temptempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'size 50mautoextend onnext 50m maxsize 20480mextent management local;

2.创建数据表空间

create tablespace user_dataloggingdatafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'size 50mautoextend onnext 50m maxsize 20480mextent management local;

3.创建用户并指定表空间

create user username identified by passworddefault tablespace user_datatemporary tablespace user_temp;

4.给用户授予权限

grant connect,resource,dba to username;