'사용자'에 해당하는 글 1건

--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;
 


WRITTEN BY
테네시왈츠
항상 겸손하게 항상 새롭게 항상 진실하게

,