- TableSpace 생성하기
1. Tablespace 생성
create tablespace pioneer_temp
datafile 'c:\oracledatafile\pioneer_temp.dbf' size 50m
autoextend on
next 10M maxsize 100m;

2. Temporaryspace 생성
create temporary tablespace imastester_temp
tempfile '/export/home/oracle/OraData/imastester_temp.dbf' size 200m reuse
autoextend on
next 10M maxsize 300m;

3. 사용자 생성
create user pioneer identified by pioneer
default tablespace pioneer_imas
temporary tablespace pioneer_temp

4. 사용자 권한 설정
grant connect, resource to pioneer;

grant dba to pioneer;

DBA 권한을 줄 경우에는 다른 권한을 줄 필요가 없다.

Start SQL*Plus by using the following command: 



$ SQLPLUS /NOLOG



Connect to the database with the SYS account by using the following command: 



SQL> CONNECT SYS/PASSWORD AS SYSDBA





SQL> STARTUP



#리스너 기동

../../oracle] lsnrctl start