--创建表空间
CREATE TABLESPACE "SPOON"
DATAFILE 'D:\SOFTWARE\ORACLE11G\ORADATA\ORCL\SPOON01.DBF' SIZE 100 M AUTOEXTEND ON NEXT 100
--创建用户并分配表空间
CREATE USER "SPOON" IDENTIFIED BY "123456" DEFAULT TABLESPACE "SPOON";

GRANT "DBA" TO "SPOON";

ALTER USER "SPOON" DEFAULT ROLE "DBA"