1 1:创建临时表空间 2 create temporary tablespace user_temp 3 tempfile 'Q:\oracle\product\10.2.0\oradata\Test\xyrj_temp.dbf' 4 size 50m 5 autoextend on 6 next 50m maxsize 20480m 7 extent management local; 8 9 2:创建数据表空间 10 create tablespace user_data 11 logging 12 datafile 'Q:\oracle\product\10.2.0\oradata\Test\xyrj_data.dbf' 13 size 50m 14 autoextend on 15 next 50m maxsize 20480m 16 extent management local; 17 18 第3步:创建用户并指定表空间 19 create user username identified by password 20 default tablespace user_data 21 temporary tablespace user_temp; 22 23 第4步:给用户授予权限 24 grant connect,resource,dba to username;