oracle-sql(创建用户、表空间)

来源:互联网 发布:简明统计软件 编辑:程序博客网 时间:2024/05/22 03:26

drop tablespace UCM_Model includingcontents and datafiles;

drop user UCM_MODEL cascade;

create tablespace UCM_Model_TabSpacedatafile '/home/newdisk/UCM_Model_TabSpace.dbf' size 100m autoextend on next100m;

create user UCM_Model identified by xxdefault tablespace UCM_Model_TabSpace Temporary TABLESPACE Temp;

grant DBA to UCM_MODEL;

0 0
原创粉丝点击