[관리] tablespace 생성 및 user생성
##################
테이블 스페이스 생성
##################
테이블 스페이스 만들기
————————–
create tablespace V_TBS생성
datafile ‘/oracle/oradata/ocp/ORAV_TBS.dbf’ size 5M
extent management local uniform size 100k;
Temporary 테이블 스페이스 만들기
—————————————
create temporary tablespace V_TEMP
tempfile ‘/oracle/oradata/ocp/ORAV_TEMP.dbf’ size 5M
extent management local uniform size 100k;
############
유저 생성하기
############
create user user명
identified by password
default tablespace 테이블스페이스명
temporary tablespace 테이블스페이스명
quota 10M on 테이블스페이스명
quota unlimited on 테이블스페이스명
6 Responses
… [Trackback]
[…] There you will find 27223 more Info on that Topic: nblog.syszone.co.kr/archives/1043 […]
… [Trackback]
[…] Read More on that Topic: nblog.syszone.co.kr/archives/1043 […]
… [Trackback]
[…] Read More Information here on that Topic: nblog.syszone.co.kr/archives/1043 […]
… [Trackback]
[…] There you can find 32407 additional Info on that Topic: nblog.syszone.co.kr/archives/1043 […]
… [Trackback]
[…] Find More to that Topic: nblog.syszone.co.kr/archives/1043 […]
… [Trackback]
[…] Read More on on that Topic: nblog.syszone.co.kr/archives/1043 […]