oracle 创建表空间及用户

//创建表空间

CREATE TABLESPACE DEMO DATAFILE 'E:\oracle\oradata\demo\demo.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; 

//创建用户

CREATE USER DEMO IDENTIFIED BY DEMO DEFAULT TABLESPACE DEMO TEMPORARY TABLESPACE temp;

//授权

GRANT connect,dba to DEMO;

//删除用户

drop user DEMO cascade;