- 创建表空间
create tablespace wbh
logging
datafile 'C:\oraclexe\app\oracle\oradata\XE\wbh.dbf'
size 500m
autoextend on
next 500m maxsize 20480m
extent management local;
- 删除表空间
DROP TABLESPACE wbh INCLUDING CONTENTS AND DATAFILES;
- 创建表空间下用户
create user wbh identified by wbh
default tablespace wbh;
- 授权
grant connect,resource,dba to wbh
网友评论