Oracle Tablespace 생성


create tablespace musieum
 datafile 'C:/oraclexe/oradata/XE/musieum.dbf'
    size 500m
    autoextend on
    next 100m
    maxsize 700m;

create temporary tablespace MUSIEUMTMP
tempfile 'C:/oraclexe/oradata/XE/musieum_temp.dbf'
size 100m
autoextend on
next 100m
maxsize 500m;
 

create user [id] identified by [pwd]
default tablespace musieum
temporary tablespace MUSIEUMTMP;


grant connect to [id]
 grant resource to [id]