본문 바로가기

work/oracle

sims테이블 스페이스&유저 생성

CREATE TABLESPACE SIMS_DATA DATAFILE
'D:\oracle\oradata\ORA815\SIMS_DATA.dbf' SIZE 50M
AUTOEXTEND ON NEXT 5M DEFAULT STORAGE
( INITIAL 20K NEXT 30K MAXEXTENTS UNLIMITED PCTINCREASE 0 );

CREATE USER "JSIMS" IDENTIFIED BY "JSIMS" DEFAULT TABLESPACE "SIMS_DATA" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT "CONNECT" TO "JSIMS";
GRANT "RESOURCE" TO "JSIMS";
GRANT UNLIMITED TABLESPACE TO "JSIMS";
ALTER USER "JSIMS" DEFAULT ROLE ALL;