-- 创建空间
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