공간사랑 :: 공간사랑

오라클 테이블스페이스 생성 및 계정 생성

database/ORACLE 2009. 7. 6. 18:57

sqlplus /nolog
connect /as sysdba

create tablespace MY_TABLE_TS
datafile '/export/home/oracle/oradata/MY_TABLE_TS.dbf'
size 1m reuse autoextend on next 1m maxsize unlimited
extent management local
/

create tablespace MY_INDEX_TS
datafile '/export/home/oracle/oradata/MY_INDEX_TS.dbf'
size 1m reuse autoextend on next 1m maxsize unlimited
extent management local
/

CREATE USER 생성하고자하는오라클사용자계정 IDENTIFIED BY "오라클사용자계정패스워드" DEFAULT TABLESPACE MY_TABLE_TS TEMPORARY TABLESPACE TEMP;

GRANT connect, resource TO 오라클사용자계정;