--创建用户表空间
CREATE TABLESPACE test_data
LOGGING
DATAFILE 'F:\oracle\product\10.2.0\oradata\orcl\TEST_DATA.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--创建用户
CREATE USER kxbin IDENTIFIED BY kxbin
DEFAULT TABLESPACE TEST_DATA;
--给用户分配权限
grant connect,resource to kxbin;
--删除表空间
drop tablespace root_data including contents and datafiles cascade constraints;
posted on 2011-09-14 16:40
kxbin 阅读(155)
评论(0) 编辑 收藏 所属分类:
ORACLE