Oracle DDL语句

1. 创建表空间

create tablespace wbh  
logging  
datafile 'C:\oraclexe\app\oracle\oradata\XE\wbh.dbf'
size 500m  
autoextend on  
next 500m maxsize 20480m  
extent management local; 

2. 删除表空间

DROP TABLESPACE wbh INCLUDING CONTENTS AND DATAFILES;

3. 创建表空间下用户

create user wbh identified by wbh
default tablespace wbh;

4. 授权

grant connect,resource,dba to wbh