创建表空间

1.创建临时表空间

CREATE TEMPORARY TABLESPACE DB_TEMP

         TEMPFILE 'D:\app\oradata\orcl\scfesco_TEMP.DBF'
         SIZE 32M
         AUTOEXTEND ON
         NEXT 32M MAXSIZE UNLIMITED
         EXTENT MANAGEMENT LOCAL;
 2.创建数据表空间
 CREATE TABLESPACE DB_SCFESCO
         LOGGING
         DATAFILE 'D:\app\oradata\orcl\scfesco.DBF'
         SIZE 200M
         AUTOEXTEND ON
         NEXT 50M MAXSIZE UNLIMITED
         EXTENT MANAGEMENT LOCAL;
 3.创建用户 并指定表空间      
CREATE USER sc_fesco IDENTIFIED BY sc_fesco
         ACCOUNT UNLOCK
         DEFAULT TABLESPACE DB_SCFESCO
         TEMPORARY TABLESPACE DB_TEMP;
4.给用户授权
GRANT CONNECT,RESOURCE TO sc_fesco;