[Oracle] DB생성 후 테이블공간, 사용자 추가

--1. Logon
 sqlplus "/as sysdba"

--2. Table Space Create

 create tablespace TS_SETDBNAME_DATA01 datafile 'C:\oracle\product\10.2.0\oradata\SETDBNAME\ts_SETDBNAME_data01.dbf' size 1000M autoextend on next 100M;

 create tablespace TS_SETDBNAME_IDX01 datafile 'C:\oracle\product\10.2.0\oradata\SETDBNAME\ts_SETDBNAME_idx01.dbf' size 500M autoextend on next 50M;

--3. USER Create

 create user mesadmin identified by admin default tablespace TS_SETDBNAME_DATA01 temporary tablespace TEMP;  
      
 grant connect , resource, dba to mesadmin;