Oracle - create table space user 테이블스페이스 유저 생성

CREATE TABLESPACE "SAMPLE_TABLE" LOGGING DATAFILE
'/oradata/iepcs/SAMPLE_TABLE1.dbf' SIZE 100M REUSE,
'/oradata/iepcs/SAMPLE_TABLE2.dbf' SIZE 100M REUSE,
'/oradata/iepcs/SAMPLE_TABLE3.dbf' SIZE 100M REUSE,
'/oradata/iepcs/SAMPLE_TABLE4.dbf' SIZE 100M REUSE,
'/oradata/iepcs/SAMPLE_TABLE5.dbf' SIZE 100M REUSE EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;


CREATE TABLESPACE "SAMPLE_INDEX" LOGGING DATAFILE
'/oraindex/iepcs/SAMPLE_INDEX01.dbf' SIZE 100M REUSE,
'/oraindex/iepcs/SAMPLE_INDEX02.dbf' SIZE 100M REUSE,
'/oraindex/iepcs/SAMPLE_INDEX03.dbf' SIZE 100M REUSE,
'/oraindex/iepcs/SAMPLE_INDEX04.dbf' SIZE 100M REUSE,
'/oraindex/iepcs/SAMPLE_INDEX05.dbf' SIZE 100M REUSE EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TEMPORARY TABLESPACE "SAMPLE_TEMP" TEMPFILE
'/oradata/iepcs/SAMPLE_TEMP01.dbf' SIZE 100M REUSE,
'/oradata/iepcs/SAMPLE_TEMP02.dbf' SIZE 100M REUSE,
'/oradata/iepcs/SAMPLE_TEMP03.dbf' SIZE 100M REUSE EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1024K;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "SAMPLE_TEMP";


CREATE USER "SAMPLEUSER" PROFILE "DEFAULT"
IDENTIFIED BY "SAMPLEUSER" DEFAULT TABLESPACE "SAMPLE_TABLE"
TEMPORARY TABLESPACE "SAMPLE_TEMP"
ACCOUNT UNLOCK;
GRANT "CONNECT" TO "SAMPLEUSER";


GRANT "CONNECT" TO "SAMPLEUSER";
GRANT "RESOURCE" TO "SAMPLEUSER";


사실 위에 내용은 Oracle Enterprise Manager Console에서 GUI로 작업할 수도 있다. -_-