oracle tablespace 생성

create tablespace sfm
 datafile 'C:\oraclexe\app\oracle\oradata\XE\sfm.dbf'
 size 500m
 autoextend on
 next 100m
 maxsize 700m;

create temporary tablespace sfm_temp
 tempfile 'C:\oraclexe\app\oracle\oradata\XE\sfm_temp.dbf'
 size 200m
 autoextend on
 next 100m
 maxsize 500m;

create user audit1 identified by audit1
default tablespace sfm
temporary tablespace sfm_temp;

grant connect to audit1;
grant resource to audit1;