表空间创建

一、创建表空间Test
create tablespace Test nologging datafile 'D路径\Test.ora' size 100m reuse autoextend on next 10m maxsize unlimited;

二、创建临时表空间TestTmp
create temporary tablespace TestTmp tempfile '路径\TestTmp.ora' size 10M;

三、创建用户并授权
-- Create the user
create user Test
  identified by Test
  default tablespace Test
  temporary tablespace TestTmp
  profile DEFAULT;
-- Grant/Revoke role privileges
grant dba to newapas with admin option;