-- 创建空间  
create tablespace chicoTest  
datafile 'D:\oradata\chicoTest_data.dbf' size 50M  
default storage (initial 500K Next 500K  minextents 1  maxextents unlimited  pctincrease 0); 

-- Oracle创建用户权限
-- 创建用户  
create user chico identified by chico default tablespace chicoTest;  
-- 授权　  
grant resource,connect,dba to chico; 

-- 删除表空间   
drop tablespace "空间名" including contents and datafiles 

-- 删除用户 

drop user "lxg" cascade 

-- 增加表空间
alter tablespace chinawater add datafile 'c:\oracle\oradata\orcl9\ADDCHINAWATER.dbf' size 200M