Oracle10g创建表空间、用户

撒也不说了，直接上代码

-- 创建临时表空间 
create temporary tablespace os_temp 
tempfile 'd:\Oracle\product\10.2.0\oradata\os_temp.dbf'
size 100m 
autoextend on
next 100m maxsize 1024m 
extent management local; 


-- 创建数据表空间 
create tablespace os_data 
datafile 'd:\Oracle\product\10.2.0\oradata\os_data.dbf'
size 100m 
autoextend on
next 100m maxsize 1024m 
extent management local; 

-- 创建用户 
create user os identified by os 
default tablespace os_data 
temporary tablespace os_temp; 

-- 给用户授予权限 
grant connect,resource to os; 
  
-- 删除表空间 
drop tablespace os_data including contents and datafiles;

-- 查询用户默认表空间及临时表空间
select username,default_tablespace ,temporary_tablespace from user_users;