Oracle 数据库创建表空间、创建用户指定表空间

//创建临时表空间     create temporary tablespace user_temp   tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'  size 50m   autoextend on   next 50m maxsize 20480m   extent management local;     //创建数据表空间   create tablespace user_data   logging   datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'  size 50m   autoextend on   next 50m maxsize 20480m   extent management local;     //创建用户并指定表空间   create user username identified by password   default tablespace user_data   temporary tablespace user_temp;     //给用户授予权限     grant connect,resource to username;