프로그래밍/DB

[펌] 오라클 TableSpace 및 사용자 생성

galad 2007. 11. 27. 14:25

/*
id : sys
pw : change_on_install
NPXTS_LDARDATA2 / NPXTS_LDARINDEX2
*/

/* 테이블 스페이스 생성(datafile의 path는 적절히) */
/* data table space 생성 */
create tablespace NPXTS_LDARDATA2
datafile 'd:\database\NPXTS_LDARDATA2.dbf' size 300m
autoextend on next 100m maxsize unlimited
default storage (initial 1m
    next 5m
    minextents 1
    maxextents unlimited
    /* pctfree 10 */
    /* pctincrease 50 */);
   
/* index table space 생성 */
create tablespace NPXTS_LDARINDEX2
datafile 'd:\database\NPXTS_LDARINDEX2.dbf' size 300m
autoextend on next 100m maxsize unlimited
default storage (initial 1m
    next 5m
    minextents 1
    maxextents unlimited
    /* pctfree 10 */
    /* pctincrease 50 */);
   

/* 사용자 생성 */
create user ldar20042
identified by ldar20042
default tablespace NPXTS_LDARDATA2
temporary tablespace temp
quota unlimited on NPXTS_LDARDATA2
quota unlimited on NPXTS_LDARINDEX2;

/* 사용자에 권한부여 */
grant connect to ldar20042;

/* 모두 지우고 다시시작할 경우 SYS로 접속하여 다음을 실행 */
/*
drop user ldar21_sm cascade;
drop tablespace ldar21_data including contents;
drop tablespace ldar21_index including contents;
*/

/*
drop user ldar2004 cascade;
drop tablespace NPXTS_ldardata including contents;
drop tablespace NPXTS_ldarindex including contents;
*/