--1.创建临时表空间
CREATE TEMPORARY TABLESPACE FDC_DATA_TEMP TEMPFILE 'C:\app\Administrator\oradata\orcl\FDC_TEMP.DBF'
SIZE 50M AUTOEXTEND ON NEXT 50M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
--2.创建数据表空间
CREATE TABLESPACE FDC_DATA LOGGING DATAFILE 'C:\app\Administrator\oradata\orcl\FDC_DATA.DBF'
SIZE 50M AUTOEXTEND ON NEXT 50M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;
--3.创建用户并指定表空间
CREATE USER FDC IDENTIFIED BY fdc DEFAULT TABLESPACE FDC_DATA TEMPORARY TABLESPACE FDC_DATA_TEMP;
--4.给用户授权
GRANT CONNECT,RESOURCE,DBA TO FDC;