데이터베이스 생성쿼리

--디비 생성쿼리

create tablespace mrkayhyun  datafile 'c:\oradata\mrkayhyun\mrkayhyun.dbf'  size 250m 

autoextend on;

create tablespace mrkayhyun_idx datafile 'c:\oradata\mrkayhyun\mrkayhyun_idx.dbf' size 100m 

autoextend on;

create temporary tablespace mrkayhyun_TMP tempfile 'c:\oradata\mrkayhyun\mrkayhyun_TMP.dbf' size 100m 

autoextend on;

create user mrkayhyun identified by mrkayhyun

default tablespace mrkayhyun temporary tablespace mrkayhyun_tmp;

grant connect, resource to mrkayhyun; 

GRANT UNLIMITED TABLESPACE TO mrkayhyun; 

commit;