반응형
--테이블 스페이스 생성
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;
반응형