表空间名称：TableSpaceA

临时表空间：TEMP

用户名称：UserA 

用户密码：123456

表空间路径：D:\ORACLE\ORADATA

--1.创建表空间
CREATE TABLESPACE "TableSpaceA"
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\TableSpaceName.ora' SIZE 100M
AUTOEXTEND
ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;

--2.创建用户
CREATE USER "UserA" PROFILE "DEFAULT"
IDENTIFIED BY "123456" DEFAULT TABLESPACE "TableSpaceA"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;

--3.用户授权
GRANT "CONNECT" TO "UserA" WITH ADMIN OPTION;
GRANT "DBA" TO "UserA" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "UserA" WITH ADMIN OPTION;