Oracle 계정 및 데이터베이스 생성

--테이블 스페이스 생성
CREATE TABLESPACE DBMSEXPERT_DATA
DATAFILE 'C:\app\dbmsexpert\oradata\orcl\DBMSEXPERT_DATA.DBF' SIZE 4G
AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON
;

--임시 테이블 스페이스 생성
CREATE TEMPORARY TABLESPACE DBMSEXPERT_TMP
TEMPFILE 'C:\app\dbmsexpert\oradata\orcl\DBMSEXPERT_TMP.DBF' SIZE 1G
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
;

--유저생성
CREATE USER DBMSEXPERT IDENTIFIED BY DBMSEXPERT
DEFAULT TABLESPACE DBMSEXPERT_DATA
TEMPORIRY TABLE SPACE DBMSEXPERT_TMP
PROFILE DEFAULT
ACCOUNT UNLOCK
;

--권한 주기
GRANT RESOURCE TO DBMSEXPERT;
GRANT CONNECT TO DBMSEXPERT;
GRANT CREATE VIEW TO DBMSEXPERT;
GRANT CREATE SYNONYM TO DBMSEXPERT;