oracle创建用户sql

CREATE TABLESPACE xj_xmcg
DATAFILE 'D:\oracle\oradata\fush\xj_xmcg0.DBF'

SIZE 50M

AUTOEXTEND ON NEXT 10M

PERMANENT ONLINE;


DROP TABLESPACE xj_xmcg INCLUDING CONTENTS;

drop user xj_xmcg cascade ;

create user xj_xmcg
identified by xj_xmcg
default tablespace xj_xmcg
temporary tablespace temp
profile default
account unlock;

grant connect,resource,dba to xj_xmcg;