테이블 스페이스, 유저 생성

DB/ORACLE 2014. 1. 10. 14:46

create tablespace TBS_TEST datafile '/home4/app/oracle/oradata/ORCL/tbs_test.dbf' size 500m autoextend on next 100m;

create temporary tablespace TBS_TESTTEMP tempfile '/home4/app/oracle/oradata/ORCL/tbs_testtemp.dbf' size 200m autoextend on next 100m;

CREATE USER TEST IDENTIFIED BY password DEFAULT TABLESPACE TBS_TEST TEMPORARY TABLESPACE TBS_TESTTEMP;

grant resource,connect to TEST;

: