Oracle创建临时表空间/表空间/创建用户/授权

--1：创建临时表空间create temporary tablespace user_temp  tempfile 'Q:\oracle\product\10.2.0\oradata\Test\xyrj_temp.dbf' size 50m  autoextend on  next 50m maxsize 20480m  extent management local;   --2：创建数据表空间create tablespace user_data  logging  datafile 'Q:\oracle\product\10.2.0\oradata\Test\xyrj_data.dbf' size 50m  autoextend on  next 50m maxsize 20480m  extent management local;   --第3步：创建用户并指定表空间create user username identified by password  default tablespace user_data  temporary tablespace user_temp;   --第4步：给用户授予权限grant connect,resource,dba to username;